This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes can PL/SQL  return a collection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "can PL/SQL  return a collection" Watch "can PL/SQL  return a collection" New topic
Author

can PL/SQL return a collection

Rakesh Gadre
Ranch Hand

Joined: Feb 22, 2003
Posts: 47
Hello,
I have a doubt like this :
I am making a call to a stored procedure. Can that procedure return a collection ?
i.e. can I have all the records from a specific table as an OUT parameter of the procedure ?
Rakesh Gadre
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

You can use reference cursors as IN/OUT parameter to return data.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: can PL/SQL return a collection
 
Similar Threads
procedures vs stored procedures
Store Procedure
Calling stored procedures
Java stored procedures and collections(ORCL)
Collection as a parameter in a Callable Statement