create or replace type NVARRAY as VARRAY(10) of number

public static Array nvafunc(NUMBER id[], Array va[], Array va2) throws SQLException
{
    Connection conn = DriverManager.getConnection("jdbc:oracle:kprb:");
    Statement stmt = conn.createStatement();
    OraclePreparedStatement ps = (OraclePreparedStatement)
    conn.prepareStatement ("SELECT NVA FROM VarrayTab WHERE ID = ?");
    ps.setNUMBER (1, id[0]);
    OracleResultSet rs = (OracleResultSet) ps.executeQuery();
    Array a = null;
    while (rs.next())
    {
        a = (Array) rs.getObject(1);
    }
    ps.close();
    id[0] = new NUMBER(id[0].intValue() + 1000);
    va[0] = va2;
    return a;
}

сreate or replace function nvafunc (x IN OUT number, y IN OUT NVARRAY, z IN NVARRAY) return NVARRAY
as language java name 'NVarrayClass.nvafunc(oracle.sql.NUMBER[], java.sql.Array[], java.sql.Array) return java.sql.Array';

	      if (_move!=null && mode==1) ((ArrayList<Move>) _move).add(new Move(span[i].intValue(),active_irr[i].doubleValue(),active_apr[i].doubleValue(),active_amo[i].doubleValue(),rest_dis[i].doubleValue(),rest_beg[i].doubleValue(),rest[i].doubleValue(),profil_remain[i].doubleValue(),profil_unpaid[i].doubleValue(),profil_amount[i].doubleValue(),rest_int[i].doubleValue()));
       }
       if (_mowe!=null && mode==1) _mowe[0] = ((OracleConnection) DriverManager.getConnection("jdbc:oracle:kprb:")).createStruct("RCMOVE", new Object[]{span,active_irr,active_apr,active_amo,rest_dis,rest_beg,rest,profil_remain,profil_unpaid,profil_amount,rest_int});

create or replace type MyType as object( i_n number
, member function okk return sys.odcinumberlist pipelined
);
/
 
Type created

create or replace type body MyType as
member function okk return sys.odcinumberlist pipelined is
  begin
    for i in 1..i_n loop
      pipe row (i*power(10,i_n-1));
    end loop;
    return;
  end;
end;
/
 
Type body created

with A as (select 1 F1,2 F2 from DUAL
            union all
           select 2 F1,3 F2 from DUAL)
select *
from A, table((MyType(A.F2)).okk()) t;
 
        F1         F2 COLUMN_VALUE
---------- ---------- ------------
         1          2           10
         1          2           20
         2          3          100
         2          3          200
         2          3          300