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

dimefx.canada_at_gmail.com wrote:
> 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~

You can create an array that way but it might be better to create it as a permanent schema object using CREATE OR REPLACE TYPE.

To pass it reference the type as the data type of the parameter.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)