RE: passing ref cursor on a procedure

[Igor Neyman]

Title: passing ref cursor on a procedure

Oops…   It’s supposed to be:   Variable lCursor  REFCURSOR;   Not: “declare lCursor REFCURSOR;”   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman Sent: Wednesday, June 04, 2003 9:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: passing ref cursor on a procedure   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; /   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----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   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