This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP 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