RE: passing ref cursor on a procedure

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 05 Jun 2003 00:20:40 -0700
Message-ID: <F001.005A9E2E.20030604064022@fatcity.com>

If
in SQL*Plus:

Just declare variable of REFCURSOR type and pass it to stored procedure:

DECLARE lCursor REFCURSOR;

Begin

<procedure_name>(par1, par2, …, :lCursor);

end;

/

<span

style='font-size:10.0pt;color:navy'>Igor Neyman, OCP DBA

<span

style='font-size:10.0pt;color:navy'>[EMAIL PROTECTED]

<span

style='font-size:10.0pt;color:navy'>

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hatzistavrou John
Sent: Wednesday, June 04, 2003
8:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: passing ref cursor on a
procedure

<span

style='font-size:12.0pt'>

Dear All,

I have a vendor procedure which I wish to run . This
procedure takes as input variables a varchar and a ref_cursor.

I know the query that is related to the ref_cursor and I wish to implicitly pass it to the procedure . How can this be
done?

<span

style='font-size:10.0pt'>Kind Regards,

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-weight:bold'>Hatzistavrou Yannis Received on Thu Jun 05 2003 - 02:20:40 CDT