• 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 ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

PL/SQL table values to JDBC

 
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
We were having a website developed using PL/SQL web toolkit and now we wish to convert the presentation logic to JSP and let the business reside in
the database layer. PLSQL packages are already there existing which gives the data in the form of PL/SQL tables. The presentation logic earlier(PL/SQL web tool kit) displayed data directly from PL/SQL tables.
We now want to make as minimal changes to the existing business logic. But facing the problem of how to read the values of PL/SQL tables through JDBC.
Its clear that JDBC does not support PL/SQL tables directly. But I would like to know what is the most efficient way(in terms of minimum change and without inducing a performance overhead) of transforming this PL/SQL table data to a structure thats retrievable through JDBC.
one way suggested is to create rectab object type in database for each PL/SQL table we are using and read the values through oracle.sql.struct.
Yet this involves creation of new database objects which we do not want to do...Is there any other way. ?
Thanks for your time
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic