Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cursor parameters in subqueries
It's a known bug, fixed in 7.3.4.
--
Alexander I.Doroshko, aid_at_grant.kharkov.ua
Jens Mayer <jmayer_at_ratundtat.com> wrote in article <3644b0ae.131897718_at_news.space.net>...
: 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)
:
: 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;
Received on Tue Jan 19 1999 - 06:14:21 CST
![]() |
![]() |