Cursor parameters in subqueries

From: Jens Mayer <jmayer_at_ratundtat.com>
Date: Sat, 07 Nov 1998 20:48:47 GMT
Message-ID: <3644b0ae.131897718@news.space.net>

Hi folks,

I created a cursor with a subquery in the Cursor Body. Now I tried to pass the Cursor-Parameters to this subquery, but Oracle cannot compile it (PLS-00320)

My Cursor was something like this:

cursor test (mypar IN CHAR)
select x,a
  from table1 t1,

         (select y,b
            from table2
         where table2.b = mypar) t2

 where t1.x = t2.y;

What's wrong ? Any suggestions ?

Thanx, Jens Received on Sat Nov 07 1998 - 14:48:47 CST