Home » SQL & PL/SQL » SQL & PL/SQL » How many OUT REF CURSOR arguments can be defined in a procedure
How many OUT REF CURSOR arguments can be defined in a procedure [message #334501] Wed, 16 July 2008 21:01 Go to next message
billgrand08
Messages: 3
Registered: July 2008
Junior Member
Thanks
Re: The maximum number of result sets can be returned from oracle procedure [message #334503 is a reply to message #334501] Wed, 16 July 2008 21:06 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
billgrand08 wrote on Wed, 16 July 2008 19:01
Thanks



I am confused.
Who are you thanking for what?
Re: The maximum number of result sets can be returned from oracle procedure [message #334506 is a reply to message #334503] Wed, 16 July 2008 21:26 Go to previous messageGo to next message
billgrand08
Messages: 3
Registered: July 2008
Junior Member
sorry.
I mean who can tell me the maximum number?
We know, the result sets are returned by OUT REF CURSOR, thus I mean for a oracle procedure, how many REF CURSORs can be output?
thanks

[Updated on: Wed, 16 July 2008 21:31]

Report message to a moderator

How many OUT REF CURSOR arguments can be defined in a procedure [message #334512 is a reply to message #334501] Wed, 16 July 2008 22:03 Go to previous messageGo to next message
billgrand08
Messages: 3
Registered: July 2008
Junior Member
anyone can tell me?
thanks
Re: How many OUT REF CURSOR arguments can be defined in a procedure [message #334513 is a reply to message #334512] Wed, 16 July 2008 22:06 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
billgrand08 wrote on Wed, 16 July 2008 20:03
anyone can tell me?
thanks


My reaction to your question is that you need to change your design!

There are two ways for you to get your question answered:
1) RTFM
2) Test code yourself

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

[Updated on: Wed, 16 July 2008 22:10] by Moderator

Report message to a moderator

Re: How many OUT REF CURSOR arguments can be defined in a procedure [message #334517 is a reply to message #334512] Wed, 16 July 2008 23:15 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Annex C PL/SQL Program Limits

Regards
Michel
Previous Topic: Convert datetime representation
Next Topic: Ref curosr or Collections
Goto Forum:
  


Current Time: Fri Dec 02 19:03:50 CST 2016

Total time taken to generate the page: 0.15942 seconds