File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Getting PL/SQL tables from JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting PL/SQL tables from JDBC" Watch "Getting PL/SQL tables from JDBC" New topic
Author

Getting PL/SQL tables from JDBC

Chris Kottom
Greenhorn

Joined: Jul 06, 2001
Posts: 1
When all else fails, post.
I'm running WebLogic 5.1 using their connection pooling with the Oracle thin driver (which we need to use at least for the time being). I've written some stored procedures (PL/SQL) that have parameters that are package-defined PL/SQL tables, and I'm having an absolute bear of a time trying to put in table parameters or get them out.
I know that WebLogic connection pools return weblogic.jdbc.pool.Connection objects when you make a request of them, and therefore when you ask for a CallableStatement, you don't get an OracleCallableStatement. So it becomes impossible to use any of the non-standard methods in that class. (Which, if I understand what I've been reading, is only possible using the OCI drivers?)
Is what I'm asking even possible? If it's not, is there anyone out there who's figured out a decent workaround to this short of catting Strings together and parsing them out in my code? I need to be able to pool connections AND pass arrays or PL/SQL tables from and to my Java code.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting PL/SQL tables from JDBC
 
Similar Threads
Execute pl/sql function which is having bind variables in java
Get ResultSet by executing anonymous pl/sql block.
OrindaBuild 4.0 - Writes Java to access Tables, PL/SQL and SQL Files
A comment inside a CallableStatement messes with parameters
java stored procedure problems