Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PL/SQL table values to JDBC

 
Kishan Kumar
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic