Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing PL/SQL Datatype in procedure from java

 
kingshuk paul
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
dear
sir/madam
Suppose a Oracle proceduere takes an in parameter of type PL/SQL type could be a cursor type,Custom Object type etc .Now with the help of
Extra library provided by Oracle classes12.jar
oarcle.sql.* .How do i create a PL/SQL datatype exactly matching the procedures input and call the
procedure to pass it?Could you kindly give any example freom java sidde to create Pl/SQL datatype
an Object type holding several rec w/c would be undetstood by Procedure as object of Pl/SQL datatype.
Or could you kindly give any URL where i get the examples.
thanx and regards
kingshuk
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic