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: Cursor parameters in subqueries

Re: Cursor parameters in subqueries

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 19 Jan 1999 12:14:21 GMT
Message-ID: <01be43a5$188fe1a0$190114c1@sister.grant.UUCP>


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

Original text of this message

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