I need a SQL stored procedure to return arrays. as OUT parameters in If i declare the array as a "table", then i cannot do table[i] := some_value. If i declare it as a VARRAY. then i need to initialialize all my VARRAY elements using a costructor which is painful ( a simple for loop does not do it). So how do i declare and use arrays in SQL stored procedures so as to return arrays as OUT paramters and access the same in JDBC kindly reply at [EMAIL PROTECTED] thanks nitin