• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 8I Java Stored Procedures returning a result Set

 
John Ryan
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic