create varray in oracle trigger and pass it to java stored procedure

Hi all,

I got a few question to here, and I am new to oracle and plsql.

1. will you be able to create varray in oracle trigger or stored procedure? something like

CREATE OR REPLACE TYPE tempArray AS VARRAY(20) of VARCHAR2(10)

2. how do you put data into tempArray?

3. how to pass this array (tempArray) to a java stored procedure or function. What data type should the java function accept as parameter?

thank you all~ Received on Thu Mar 30 2006 - 16:14:54 CST