This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Passing PL/SQL table from Stored Proc to Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Passing PL/SQL table from Stored Proc to Java" Watch "Passing PL/SQL table from Stored Proc to Java" New topic
Author

Passing PL/SQL table from Stored Proc to Java

Abhishek Asthana
Ranch Hand

Joined: Sep 08, 2004
Posts: 146
MY scenario is something like this:
I have to call a packaged PL/SQL proc from my Java program. The procedure should set a table of varchar as out parameter, which I can pick up in my Java program.

This is the definition of the table type: type STR_ARRAY is table of varchar2(1000);

I know how to pass a String array from Java to PL/SQL (by creating descriptor for the array) but I am not able to understand, how to do this in my Java program.

Any links, any suggestions, any examples would be great help.

Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing PL/SQL table from Stored Proc to Java
 
Similar Threads
asynchronous pl/sql call from JSP
copying file into database
Type mismatch
How to pass BLOB to a PL/SQL Stored Procedure
Passing java arrays to PL/SQL and vice versa