A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
Passing PL/SQL table from Stored Proc to Java
Joined: Sep 08, 2004
Aug 07, 2007 23:24:00
MY scenario is something like this:
I have to call a packaged PL/SQL proc from my
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Passing PL/SQL table from Stored Proc to Java
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015