Two Laptop Bag*
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
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Passing PL/SQL table from Stored Proc to Java