Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Arrays and Java Stored Procedures
In case anyone else present/future has the same problem, this is how
I've now solved it.
create or replace type curr as object (
id number(2),
type varchar2(100),
amount number(9,2),
date date,
new_amount number(9,2)
);
create type objects as varray(10) of curr;
create or replace function getNewValue(allValues objects) RETURN
VARCHAR2 as language JAVA name 'MyClass.getNewValue(oracle.sql.ARRAY)
return java.lang.String';
Rgds
C.
-- cnsxxx09_at_netscape.net (C) wrote in message news:<938e983f.0109270757.40dda0ae_at_posting.google.com>...Received on Fri Sep 28 2001 - 07:38:38 CDT
> Hi,
>
> I want to pass 0..x sets of data into a Java Stored Procedure; and
> each set of data is a 4 element array.
>
> So effectively I want to pass an array of an array into my procedure.
>
> Is this possible to do from a PL/SQL call to the Java Stored
> Procedure?
>
> And if so, is it possible to have the arrays as Object arrays (ie not
> defined to a type)?
>
> Many TIA
>
> Chris
> -=-=-