OraFAQ Forum: SQL & PL/SQL » How many OUT REF CURSOR arguments can be defined in a procedure

Home » SQL & PL/SQL » SQL & PL/SQL » How many OUT REF CURSOR arguments can be defined in a procedure

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

How many OUT REF CURSOR arguments can be defined in a procedure [message #334501]

Wed, 16 July 2008 21:01

billgrand08
Messages: 3
Registered: July 2008

Junior Member

Thanks

Report message to a moderator

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

BlackSwan
Messages: 25478
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?

Report message to a moderator

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

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

billgrand08
Messages: 3
Registered: July 2008

Junior Member

anyone can tell me?
thanks

Report message to a moderator

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

BlackSwan
Messages: 25478
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

Michel Cadot
Messages: 64965
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

Report message to a moderator

Previous Topic:	Convert datetime representation
Next Topic:	Ref curosr or Collections

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 28 05:48:50 CDT 2017

Total time taken to generate the page: 0.08531 seconds