Thread: Bad rowtype on PL/SQL Oracle -- does anyone know?

Bad rowtype on PL/SQL Oracle -- does anyone know?

From
Josh Berkus
Date:
Folks,

We need some help from an active Oracle PL/SQL programmer.

What would Oracle PL/SQL do in this case:

DECLARE some_rec some_table%ROWTYPE

SELECT a, b  --but not c, d
FROM some_table INTO some_rec
WHERE a = x;

We're trying to determine what PL/pgSQL should do if given a select statement
which does not match the declared %ROWTYPE, and were wondering what PL/SQL
does.  My PL/SQL manual does not make it clear, and I don't have  a running
8i to test on.

--
-Josh BerkusAglio Database SolutionsSan Francisco