aspose file tools*
The moose likes JDBC and the fly likes Oracle 8I Java Stored Procedures returning a result Set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle 8I Java Stored Procedures returning a result Set" Watch "Oracle 8I Java Stored Procedures returning a result Set" New topic
Author

Oracle 8I Java Stored Procedures returning a result Set

John Ryan
Ranch Hand

Joined: Mar 14, 2001
Posts: 124
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle 8I Java Stored Procedures returning a result Set