Home » SQL & PL/SQL » SQL & PL/SQL » How can I get multiple rows returned from procedure (Oracle)
How can I get multiple rows returned from procedure [message #396533] Tue, 07 April 2009 02:34 Go to next message
smittal17
Messages: 7
Registered: March 2009
Junior Member
Hello,

I want to to get multiple rows returned from procedure.How should I do that ?
I think we have to call Cursors from within but I am not getting how to do .Can anybdy help
Re: How can I get multiple rows returned from procedure [message #396539 is a reply to message #396533] Tue, 07 April 2009 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can return a ref cursor (or an array).

PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Re: How can I get multiple rows returned from procedure [message #396659 is a reply to message #396533] Tue, 07 April 2009 08:50 Go to previous messageGo to next message
mohan_krishnan83
Messages: 10
Registered: July 2006
Junior Member
You can also use TABLE functions to return multiple rows to caller.See on TABLE functions
Re: How can I get multiple rows returned from procedure [message #396736 is a reply to message #396533] Tue, 07 April 2009 21:49 Go to previous message
smittal17
Messages: 7
Registered: March 2009
Junior Member
Thanks every one I will have a look on these functions ...
Previous Topic: Compute Case Statement
Next Topic: Diff b/w drop and unused
Goto Forum:
  


Current Time: Tue Dec 06 15:55:06 CST 2016

Total time taken to generate the page: 0.09915 seconds