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.