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

[phani babu]

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]

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