How to return a PLSQL table to JDBC, or convert it into a cursor?

From: <hchen_at_time-0.com>
Date: Wed, 19 May 1999 19:13:46 GMT
Message-ID: <7hv2h8$g36$1@nnrp1.deja.com>

Hi,
My java code calls a PLSQL funcion via JDBC. Can I return a PLSQL table (indexed by binary_integer) to the java code?

It seems that there are two choices:
1. return each row of the PLSQL table via a cursor variable 2. convert the PLSQL table to a java array

But I can't find a solution in either way.

It seems like this task can be done by PL/SQL 8.0 using nested table , not in 2.0 (index-by table). But our database in in Oracle 7.3.

Please help.

Thanks in advance.
--

Hang Chen, Software Engineer
Time0 Group, Perot Systems

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Wed May 19 1999 - 14:13:46 CDT