wood burning stoves*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Similar Threads
How to pass java objects to PL/SQL procedures?
Pass Hashtable to PL/SQL procedure
How to pass BLOB to a PL/SQL Stored Procedure
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
Closing cursor in a stored procedure when invoked from a callable statement