Home » Developer & Programmer » Forms » Returning Multiple result sets (PLSQL 10G)
Returning Multiple result sets [message #277863] Wed, 31 October 2007 23:52 Go to next message
farook_quisar
Messages: 12
Registered: May 2006
Location: Abu Dhabi
Junior Member

I want to return multiple datasets in one procedure. I have the option to return multiple REF-CUROSR variable or multiple object tables (containing data) . which option would be preferable on considering performance.

thnx
Farook Quisar
Re: Returning Multiple result sets [message #279505 is a reply to message #277863] Thu, 08 November 2007 18:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
They're both about the same. Do whichever is the easiest to program and maintain.

David
icon4.gif  Re: Returning Multiple result sets [message #279825 is a reply to message #279505] Sat, 10 November 2007 21:24 Go to previous messageGo to next message
farook_quisar
Messages: 12
Registered: May 2006
Location: Abu Dhabi
Junior Member

Dear David,

Thanks for your time to read my question.

I believe both are not same. with ref-curosr it is not sending data, only a pointer to the data is being sent. but when it is used object tables it is being sent the data itself. please correct me if anyting wrong.

Thnx
Farook Quisar

Re: Returning Multiple result sets [message #280525 is a reply to message #279825] Wed, 14 November 2007 00:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is the procedure in the Form or in the Database? This is the Forms forum. I believe the load is about the same for a procedure in a Form.

David
Previous Topic: reading multiple excel file using WEBUTIL functions
Next Topic: Poblem In Call and Run Form
Goto Forum:
  


Current Time: Sat Dec 10 16:31:56 CST 2016

Total time taken to generate the page: 0.09402 seconds