Home » Developer & Programmer » JDeveloper, Java & XML » oracle.jdbc.driver.OracleTypes.CURSOR as in parameter to PL/SQL
oracle.jdbc.driver.OracleTypes.CURSOR as in parameter to PL/SQL [message #92076] Sun, 29 February 2004 16:49 Go to next message
Oliver Salmon
Messages: 3
Registered: February 2004
Junior Member
Hi,
I'm sure this may have been answered before but, I desperately need to find out how to use a cursor of type oracle.jdbc.driver.OracleTypes.CURSOR, gained from the out parameter of a callable statement to a PL/SQL stored procedure, as an in parameter of a different callable statement, calling a PL/SQL stored procedure residing on a remote oracle server from the first sp. I have had a lot of trouble trying to find out how to do this and am coming to the conclusion that it can't be done. If it is possible I'd be very grateful for an example. If it is not possible I'd be grateful for a work around.
Both databases are Oracle 9.2.0.4.0 - 64bit Production and I am using the Oracle9i 9.2.0.3 JDBC Drivers. Because of architectural constraints it is not possible to use a database link between the databases.
Thanks in advance for your help,

Oliver
Re: oracle.jdbc.driver.OracleTypes.CURSOR as in parameter to PL/SQL [message #92104 is a reply to message #92076] Wed, 10 March 2004 17:33 Go to previous message
Oliver Salmon
Messages: 3
Registered: February 2004
Junior Member
The answer I've found is that this is not possible, although there's a mapping from a cursor to a java.sql.ResultSet there is no reverse mapping. The best solution I've found is to change the PL/SQL parameter to a VARRAY and populate with a record whose type is defined in the target database using the Oracle JDBC type STRUCT (can be done dynamically in JDBC).
Oliver
Previous Topic: ojdbc14.jar - setCacheInactivityTimeout
Next Topic: JDBC CALL IN OUT REF CURSOR PARAMETER
Goto Forum:
  


Current Time: Fri Mar 29 01:50:23 CDT 2024