This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Oracle 8I Java Stored Procedures returning a result Set
 
jQuery in Action, 3rd edition