aspose file tools
The moose likes JDBC and the fly likes TABLE type as IN / OUT in a Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "TABLE type as IN / OUT in a Stored Procedure" Watch "TABLE type as IN / OUT in a Stored Procedure" New topic
Author

TABLE type as IN / OUT in a Stored Procedure

L Goundalkar
Ranch Hand

Joined: Jul 05, 2001
Posts: 395
Hi,
I have a stored procedure which takes TABLE type of variable as IN parameter. How Can I set a interget type array to this Stored Procedure as IN paramter using setters available in CallableStatement interface.?
Also please let me know how can I get OUT parameter which is defined as TABLE type in PL/SQL.
Thanks for the time.


<b>L G Goundalkar</b><br /> <a href="mailto:lggoundalkar@yahoo.com" rel="nofollow">lggoundalkar@yahoo.com</a> <br />Sun Certified Programmer for Java 2 Platform.<br />Sun Certified Web Component Developer for J2EE.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: TABLE type as IN / OUT in a Stored Procedure
 
Similar Threads
How to pass a ROWTYPE parameter to an Oracle Stored Procedure?
RowSet Problem in DB2
pass a cursor between databases
Packed decimal conversion - Java
How to pass BLOB to a PL/SQL Stored Procedure