RE: passing ref cursor on a procedure

<FONT face=Arial color=#0000ff
size=2>example

<FONT face=Tahoma

  size=2>-----Original Message-----From: Hatzistavrou John   [mailto:[EMAIL PROTECTED]Sent: Wednesday, June   04, 2003 2:40 PMTo: Multiple recipients of list   ORACLE-LSubject: passing ref cursor on a   procedure
  D<FONT
  face=Arial size=2>ear All,
  I have a vendor
  procedure which I wish to run .<SPAN
  lang=el> <FONT face=Arial
  size=2>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   .<SPAN
  lang=en-us> How can this
  be done?<SPAN
  lang=el>
<FONT

  face="Times New Roman" size=2>Kind Regards,
<FONT face="Times New Roman"

  size=2>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.