Oracle-L: RE: passing ref cursor on a procedure

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Wed, 04 Jun 2003 08:10:22 -0800
Message-ID: <F001.005AA0B3.20030604081022@fatcity.com>

Example

Package ll is

Type lrec is record(

A integer,

B varchar2(72));

Type lrectype is REF CURSOR return lrec;

Procedure getl( par1 in varchar2,

                       Xcursor IN OUT lrectype);

End;

Now ,

HOW do I execute procedure getl from sqlplus?

Kind Regards,

Hatzistavrou Yannis

-----Original Message-----
Sent: Wednesday, June 04, 2003 6:05 PM
To: Multiple recipients of list ORACLE-L

example

-----Original Message-----
Sent: Wednesday, June 04, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L

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?

Kind Regards,

Hatzistavrou Yannis

This electronic transmission is strictly confidential and intended solely

for the addressee. It may contain information which is covered by legal,

professional or other privilege. If you are not the intended addressee,

you must not disclose, copy or take any action in reliance of this

transmission. If you have received this transmission in error,

please notify the sender as soon as possible.

This footnote also confirms that this message has been swept

for computer viruses.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hatzistavrou John
INET: John.Hatzistavrou.sema_at_mail.tellas.gr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 04 2003 - 11:10:22 CDT