Oracle 8I Java Stored Procedures returning a result Set
John Ryan
Ranch Hand
Joined: Mar 14, 2001
Posts: 124
posted
0
Hi, Does anyone know if it is possible to write a Java Stored Procedure in Oracle 8i to return a Result Set. I have read that this is not possible in 8i as does not have any Data Type in the Oracle.sql package to map to a REF CUROSR. My understanding is that the oracle.sql package provides wrappers for the SQL Data types. Seemingly this is possible in Oracle 9i but i havent be able to find out how.... Any help would be appreciated, Thanks, John
John Ryan
Ranch Hand
Joined: Mar 14, 2001
Posts: 124
posted
0
Well i found an answer to my own question so i might as well share it with you all. Seems that this cannot be be done in 8i. See this link Java Developer Connection
subject: Oracle 8I Java Stored Procedures returning a result Set
0
