Win a copy of Modern JavaScript for the Impatient this week in the Server-Side JavaScript and NodeJS 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 all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

PL/SQL table values to JDBC

Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Hang a left on main. Then read this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic