Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing complex types to Java stored procedures

78280Aug 11 2005 — edited Apr 21 2006
Hello. I would like to pass a ref cursor from a PL/SQL stored procedure to a Java stored procedure. Currently, we have a number of Java stored procedures which accept primatives as input parameters, but I am unsure of how to accept a more complex object. I have tried two ways so far, but both have been unsuccessul:

1) Test.test(oracle.sql.REF) return java.lang.String

2) Test.test(java.sql.ResultSet) return java.lang.String

Any help would be appreciated. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2006
Added on Aug 11 2005
#java-database-connectivity-jdbc
5 comments
984 views