Win a copy of React Cookbook: Recipes for Mastering the React Framework this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Frits Walraven
  • Himai Minh

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

Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
please buy my thing and then I'll have more money:
the value of filler advertising in 2021
    Bookmark Topic Watch Topic
  • New Topic