Message-Id: <10661.120317@fatcity.com> From: "Koivu, Lisa" Date: Thu, 26 Oct 2000 14:02:15 -0400 Subject: refcursor question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C03F76.E1740CC6 Content-Type: text/plain; charset="iso-8859-1" I am fighting with refcursors and it is getting unpleasant. I need to use bind variables, so my statement is like what follows: OPEN refcursor FOR 'select :bind1, :bind2' from dual' USING v1, v2; The select statement is much more complex, and results in the always enlightening ORA-600 [15860], [], [], [], [], [], [], [] My question is, can I use parameterized cursors here? CURSOR c1 (in_parm1 VARCHAR2) IS SELECT col1 FROM table WHERE col2 = in_parm1; ... OPEN refcursor FOR c1(v1); It doesn't like this. Any suggestions are appreciated - Thank You Lisa Rutland Koivu Oracle Database Dork Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." ------_=_NextPart_001_01C03F76.E1740CC6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable refcursor question

I am fighting with refcursors and it = is getting unpleasant.  I need to use bind variables, so my = statement is like what follows:

OPEN refcursor FOR 'select :bind1, = :bind2' from dual' USING v1, v2;

The select statement is much more = complex, and results in the always enlightening ORA-600 [15860], [], = [], [], [], [], [], []

My question is, can I use = parameterized cursors here?

CURSOR c1 (in_parm1 VARCHAR2)
IS
SELECT col1
FROM  table
WHERE col2 =3D in_parm1;

...


OPEN refcursor FOR c1(v1);

It doesn't like this. 

Any suggestions are appreciated - = Thank You

Lisa Rutland Koivu
Oracle Database Dork
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  = 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The = information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon =