A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
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
Have you checked out
subject: can PL/SQL return a collection
procedures vs stored procedures
Java stored procedures and collections(ORCL)
Calling stored procedures
Collection as a parameter in a Callable Statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015