Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
JDBC and Relational Databases
Passing PL/SQL table from Stored Proc to Java
posted 10 years ago
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
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.
It is sorta covered in the
JavaRanch Style Guide
Boost this thread!
How to pass BLOB to a PL/SQL Stored Procedure
asynchronous pl/sql call from JSP
Passing java arrays to PL/SQL and vice versa
copying file into database