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.
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
Joined: Mar 14, 2001
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