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
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: 17276

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

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: can PL/SQL return a collection
It's not a secret anymore!