This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "PL/SQL table values to JDBC" Watch "PL/SQL table values to JDBC" New topic

PL/SQL table values to JDBC

Kishan Kumar
Ranch Hand

Joined: Sep 26, 2000
Posts: 130
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
I agree. Here's the link:
subject: PL/SQL table values to JDBC
It's not a secret anymore!