Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
phani babu
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic