File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Workarounds for Oracle Table, Row, Record, Boolean data types
 
Similar Threads
Multi-row insert
Stored procedure call removes spaces in text
passing 2D arrays to Oracle Stored Procedure with/without using JPublisher
help with how to call from JPA oracle stored procedure with array as IN parameter
Array as input to stored procedure.