Re: Returning VARRAY to java

From: Dave Godbey <luhbey_at_erols.com>
Date: Wed, 01 Nov 2000 19:43:55 -0500
Message-ID: <3A00B8CA.B916DCC5@erols.com>

I did similar thing in reverse. In Java, I created a function that performed a calculation and returned an array. In Oracle, I created a VARRAY. Using the Java class ARRAY, I passed the Java array into my PL/SQL procedure.

Bruno Georges wrote:

> Hi
> I 'd like to know if anyone has an exmaple of a stored proc which
> returns a set of row from a simple select and then is handled by a
> java
> resultset.
>
> I couldn't find a way in JDBC2.0 with Oracle stored Proc to do it.
>
> If you could give any direction , I will appreicate.
>
> Regards
>
> Bruno Georges
> Senior Developer
> Xbridge Ltd
> bruno_at_xbridge.com
Received on Wed Nov 01 2000 - 18:43:55 CST