This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Other Application Frameworks and the fly likes How to read object collection as an out parameter of stored procedure(Oracle)? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Bookmark "How to read object collection as an out parameter of stored procedure(Oracle)?" Watch "How to read object collection as an out parameter of stored procedure(Oracle)?" New topic
Author

How to read object collection as an out parameter of stored procedure(Oracle)?

phani babu
Greenhorn

Joined: May 16, 2006
Posts: 8
I have the following procedure with person_obj_coll as an out parameter.

CREATE OR REPLACE
TYPE person_obj As object
(
Name VARCHAR2(50)
Address varchar2(50)
Phone number
)
/

CREATE OR REPLACE
type person_obj_coll as table of person_obj
/

PROCEDURE pr_getAllPersonDetails(po_ErrorCode OUT NUMBER,
po_ErrorText OUT VARCHAR2,
po_person_coll out person_obj_coll);

I'm using spring jdbc to access the data from daatbase.How can I read this object collection in my spring application?.
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Well one option is you could extend Spring's "StoredProcedure" class.

http://static.springframework.org/spring/docs/2.5.x/reference/jdbc.html#jdbc-StoredProcedure

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to read object collection as an out parameter of stored procedure(Oracle)?
 
Similar Threads
JDBC program to invoke stored procedure with complex input types
Java - Passing Object to Storeprocedure (Spring JDBCTemplate)
Registering IN OUT parameter
Passing String array as out parameter to stored procedure
Varchar & Varchar2 in Stored procedure