What is the purpose of Ref Cursor and OUT Parameter in PLSQL Function? Give Examples for each?

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Jun 9th, 2010

Main advantage of Ref cursor is you can get the output as record set. For example if you are using Java or .Net or cristal reports for reporting purpose then you can use Ref cursors and write a subpro...

pratap557

 Profile Answers by pratap557 Questions by pratap557

• Oct 13th, 2009

By Ref cursor we can send record set to the calling programLike .NET VB page can get recordset as datatable from ref cursor returned by a procedure.OUT parameter sends only one value from procedure

Answer Question  Select Best Answer