File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
can PL/SQL return a collection
Joined: Feb 22, 2003
Apr 14, 2003 04:09:00
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 ?
Joined: Feb 05, 2001
Apr 14, 2003 17:24:00
You can use reference cursors as IN/OUT parameter to return data.
Perfect World Programming, LLC
Two Laptop Bag
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: can PL/SQL return a collection
Java stored procedures and collections(ORCL)
procedures vs stored procedures
Collection as a parameter in a Callable Statement
Calling stored procedures
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014