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 Berkus
Aglio Database Solutions
San Francisco