Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Is a CURSOR always Dynamic SQL ?? (pls-00455)
The syntax is open ... for <sql statement>
The second time you don't supply a sql statement as parameter but a
cursor.
A cursor is a handle to a sql statement, so you can't use it as
parameter to another cursor.
The error you are getting is to be expected.
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Jul 28 2005 - 04:50:33 CDT