Terry, SQL and PL/SQL are out of sync in functionality
until 9i. What works in SQL might not work in SQL fired
inside PL/SQL. Use dynamic SQL inside PL/SQL (EXECUTE IMMEDIATE)
to get the same functionality.
This is also why you can use CASE in SQL in 8i and can't inside
PL/SQL until 9i.
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca.x> wrote in message
news:mOF6c.218186$A12.207036_at_edtnps84...
> Does it work in PL/SQL in 9i or 10g? I tried in 8174 and it failed:
>
Received on Sat Mar 20 2004 - 03:31:28 CST
