File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Passing PL/SQL Datatype in procedure from java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Passing PL/SQL Datatype in procedure from java" Watch "Passing PL/SQL Datatype in procedure from java" New topic
Author

Passing PL/SQL Datatype in procedure from java

kingshuk paul
Greenhorn

Joined: Dec 05, 2001
Posts: 16
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


kin
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing PL/SQL Datatype in procedure from java