• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Adv JDBC ?

 
Gregg Wachter
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Has anyone attempted to use jdbc drivers to access an Oracle StoredProcedure return a CURSOR or pl/sql Table datatype???
I'm trying to access using the OracleType.CURSOR as technet.oracle.com implies you can. But, for some reason I get an exception saying that I can't set an out parameter as CURSOR without getting an exception on the executeQuery command.
Any thoughts?
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This sounds a lot like you are connecting to a 7.x or earlier Oracle database. Previous to 8i, Oracle did not support returning a cursor from a stored procedure, If you are connecting to 8i and the stored procedure returns a cursor, you can try setting the return type as Types.OBJECT then cast it to a ResultSet object. (In my experiance with the Oracle packages, they have a lot of unresolved errors, so I try to stay with the java.sql package)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic