Passing in Arrays when calling a Stored Proc in Oracle

Hello

I've uploaded a method in java to the Oracle Server:

package com.mycomp.analytics;
public class Statistics
{

    public static double getSum(double[] data)     {

        return getSum(data, 0, data.length);     }
}

I've also set up a procedure to call this Java Method:

CREATE OR REPLACE PROCEDURE STA_GET_SUM (  data IN NUMBER,
 sum OUT NUMBER
 ) AS LANGUAGE JAVA
 NAME 'com.mycomp.analytics.Statistics.getSum(double[])';

The Problem is, when calling STA_GET_SUM, how can I declare and initialize a double array, and then pass it to the procedure. Any sample SQL would be much appreciated.

Thanks
AJT Received on Fri Feb 14 2003 - 11:19:50 CST