Re: Cursor parameters in subqueries

Try to write your cursor like this :

cursor test (mypar IN CHAR)
select t1.x, t1.a, t2.y, t2.b
  from table1 t1,table t2
 where t1.x = t2.y

     and t2.b = mypar;

Dragan

Jens Mayer wrote:

> 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 - 19:03:53 CST