my dog learned polymorphism*
The moose likes JDBC and the fly likes Workarounds for Oracle Table, Row, Record, Boolean data types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Workarounds for Oracle Table, Row, Record, Boolean data types" Watch "Workarounds for Oracle Table, Row, Record, Boolean data types" New topic
Author

Workarounds for Oracle Table, Row, Record, Boolean data types

Chris Allen
Ranch Hand

Joined: Feb 01, 2003
Posts: 127
As I understand it, there is no support for the Oracle Table, Row, Recid, Record, Boolean data types using the current JDBC implementations. I have read that in the JDBC 3.0 specification, there might be some support for RECID. I was wondering what other folks have done to deal with this issue. In my case, I am calling an Oracle stored procedure which has two output parameters of type TABLE. The only workaround I have found is to have the stored procedures changed to return a REF CURSOR data type which can then be casted into a ResultSet. Another alternative is to have a "wrapper" procedure which takes the original stored procedure output and returns it using data types that JDBC can consume. Any options/experiences would be greatly appreciated!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Workarounds for Oracle Table, Row, Record, Boolean data types