Re: varray? plsql tables? for Java

From: Jan Vissers <jan_vissers_at_planet.nl>
Date: Thu, 14 Dec 2000 19:38:00 +0100
Message-ID: <91b492$1kqud$1@reader4.wxs.nl>

Using JDBC2.0 it is possible to pass a PL/SQL table consisting of scalair fields only. Maybe a better idea to transform the pl/sql table into a object table, since you'd probably have more luck passing those around in Java.

Hope this helps,
Jan.

[Have a look at the JDBC 8.1.7 Guide]

<seanldus_at_my-deja.com> wrote in message news:9190kj$gj5$1_at_nnrp1.deja.com...
> I'm hoping to be able to create a stored procedure or function in
> Oracle that is accessable in Java using JDBC which has as one of its
> parameters a list of name-value pairs. What is the easiest way to do
> this? Varray? Can I pass a pl/sql table to Java? any Ideas?
>
> Help is appreciated.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 14 2000 - 12:38:00 CST