Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Is a CURSOR always Dynamic SQL ?? (pls-00455)

Re: PL/SQL: Is a CURSOR always Dynamic SQL ?? (pls-00455)

From: <sybrandb_at_yahoo.com>
Date: 28 Jul 2005 02:50:33 -0700
Message-ID: <1122544233.599616.195800@g47g2000cwa.googlegroups.com>


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 DBA
Received on Thu Jul 28 2005 - 04:50:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US