How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ?

Questions by mkatpatal   answers by mkatpatal

Showing Answers 1 - 4 of 4 Answers

Rama Krishna,TCS

  • Aug 9th, 2006
 

Hi Mukund!!

       You have to return the selected cursor as OUT parameter and again you have to fetch the data from that OUT cursor..

Thanks&Regds

Ramki

  Was this answer useful?  Yes

manish dudhe

  • Oct 15th, 2007
 

Hi,

User Ref cursor as out parameter in proc


and execute as below

sql>var s refcursor

sql>exec demo_proc('manish',:s);

sql>print s

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions