*
The moose likes JDBC and the fly likes PL/SQL table values to JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PL/SQL table values to JDBC" Watch "PL/SQL table values to JDBC" New topic
Author

PL/SQL table values to JDBC

Kishan Kumar
Ranch Hand

Joined: Sep 26, 2000
Posts: 130
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


Regards,<BR>V. Kishan Kumar
 
wood burning stoves
 
subject: PL/SQL table values to JDBC
 
Similar Threads
FireStorm/DAO 2.4 Final Release Candidate
Regarding pl/sql
New to Hibernate
Prepared Stmt or Stored Procedure ?
PL/SQL Problem