File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing PL/SQL table from Stored Proc to Java

Abhishek Asthana
Ranch Hand
Posts: 146
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

I agree. Here's the link:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic