can PL/SQL return a collection

Ranch Hand

Posts: 47

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 17347

I like...

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.