OraFAQ Forum: Forms » Returning Multiple result sets

Home » Developer & Programmer » Forms » Returning Multiple result sets (PLSQL 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Returning Multiple result sets [message #277863]

Wed, 31 October 2007 23:52

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

Report message to a moderator

Re: Returning Multiple result sets [message #279505 is a reply to message #277863]

Thu, 08 November 2007 18:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

They're both about the same. Do whichever is the easiest to program and maintain.

David

Report message to a moderator

Re: Returning Multiple result sets [message #279825 is a reply to message #279505]

Sat, 10 November 2007 21:24

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

Report message to a moderator

Re: Returning Multiple result sets [message #280525 is a reply to message #279825]

Wed, 14 November 2007 00:06

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 02:34:53 CST 2025