It's not a secret anymore!*
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
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: 17250
    
    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
 
 
subject: How to read object collection as an out parameter of stored procedure(Oracle)?