Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Arrays and Java Stored Procedures

Re: Arrays and Java Stored Procedures

From: C <cnsxxx09_at_netscape.net>
Date: 28 Sep 2001 05:38:38 -0700
Message-ID: <938e983f.0109280438.5ac3d9da@posting.google.com>


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>...

> 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
> -=-=-
Received on Fri Sep 28 2001 - 07:38:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US