File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Chris Allen
Ranch Hand
Posts: 127
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic