RE: passing ref cursor on a procedure

[Hatzistavrou John]

Title: passing ref cursor on a procedure

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----- From: Regis Biassala [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: passing ref cursor on a procedure   example -----Original Message----- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: passing ref cursor on a procedure 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. **********************************************************************