Meaningless Drivel is fun!*
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
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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Workarounds for Oracle Table, Row, Record, Boolean data types
 
Similar Threads
Stored procedure call removes spaces in text
help with how to call from JPA oracle stored procedure with array as IN parameter
passing 2D arrays to Oracle Stored Procedure with/without using JPublisher
Array as input to stored procedure.
Multi-row insert