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

can PL/SQL return a collection

Rakesh Gadre
Ranch Hand

Joined: Feb 22, 2003
Posts: 47
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

Joined: Feb 05, 2001
Posts: 17249

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

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
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