ops$tkyte@ORA9IR2> create or replace type myType as table of sys.anyData
  2  /

Type created.

ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> declare
  2      l_data myType := myType( sys.anyData.convertNumber(5),
  3                               sys.anyData.convertDate( sysdate ),
  4                               sys.anyData.convertVarchar2('Hello world' ) );
  5  begin
  6      null;
  7  end;
  8  /

PL/SQL procedure successfully completed.


you could have a collection (nested table or varray) of anydata 

specifically 

ops$tkyte%ORA10GR2> create table sample ( x varchar2(10) );

Table created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create or replace Type numarray is table of varchar2(10);
  2  /

Type created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create or replace PROCEDURE ARR (W numarray)
  2  IS
  3  BEGIN
  4          if ( w is not null and w.count > 0 )
  5          then
  6                  forall i in 1 .. w.count
  7                          insert into sample values(W(i));
  8          end if;
  9  END;
 10  /

Procedure created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> declare
  2  data numArray := numarray('1','2','3','4','5');
  3  begin
  4  ARR(data);
  5  end;
  6  /

PL/SQL procedure successfully completed.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> DECLARE
  2    W NUMARRAY;
  3  BEGIN
  4    ARR( W => W );
  5  END;
  6  /

PL/SQL procedure successfully completed.

declare 
  w numarray := numarray();
begin
  .... start using w, w.extend and w(1) := whatever ....

insert into t (a,b,c,d,e,msg) values ( w(1), w(2), w(3), w(4), w(5), w(6) );

ops$tkyte%ORA10GR2> create table insat_sat_det_mstr
  2  (SNO NUMBER(38),NAME VARCHAR2(40),CMV BLOB,WVW BLOB,OLR
  3  BLOB,QPE    BLOB,CTTI    BLOB,GPS    BLOB,SYS_DATE    DATE, sat_name varchar2(30));

Table created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create or replace PROCEDURE SAT (
  2   P_NAME    VARCHAR2,
  3   P_TYPE        VARCHAR2,
  4   P_RET_VAL     OUT BLOB
  5  )
  6  AS
  7  BEGIN
  8     select decode( p_type, 'CMV', cmv, 'WVW', wvw, 'OLR', olr, 'QPE', qpe, 'CTTI', ctti, 'GPS', gps )
  9       into p_ret_val
 10       from insat_sat_det_mstr
 11      where name = p_name
 12        and sys_date = (select max(sys_date) from insat_sat_det_mstr where trim(sat_name) = 'INSAT-3A' );
 13  END;
 14  /

Procedure created.

ops$tkyte%ORA11GR2> CREATE OR REPLACE TYPE STRARRAY AS TABLE OF VARCHAR2 (255)
  2  /

Type created.

ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> CREATE OR REPLACE PACKAGE DEMO_PASSING_PKG
  2  AS
  3     -- Varchar2's are most easily mapped to the java String type
  4     PROCEDURE PASS (
  5        P_IN IN VARCHAR2,
  6        P_OUT OUT VARCHAR2)
  7     AS
  8        LANGUAGE JAVA
  9           NAME 'demo_passing_pkg.pass( java.lang.String,
 10                                        java.lang.String[] )';
 11
 12       PROCEDURE PASS (
 13          P_IN IN STRARRAY,
 14          P_OUT OUT STRARRAY)
 15       AS
 16          LANGUAGE JAVA
 17             NAME 'demo_passing_pkg.pass_str_array( oracle.sql.ARRAY,
 18                                                 oracle.sql.ARRAY[] )';
 19
 20     FUNCTION RETURN_STRING
 21        RETURN VARCHAR2
 22     AS
 23        LANGUAGE JAVA
 24           NAME 'demo_passing_pkg.return_string() return
 25             java.lang.String';
 26  END DEMO_PASSING_PKG;
 27  /

Package created.

ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> SET define off
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> CREATE OR REPLACE AND COMPILE
  2  JAVA SOURCE NAMED "demo_passing_pkg"
  3  AS
  4  import java.io.*;
  5  import java.sql.*;
  6  import java.math.*;
  7  import oracle.sql.*;
  8  import oracle.jdbc.driver.*;
  9
 10  public class demo_passing_pkg extends Object{
 11
 12  public static void pass( java.lang.String p_in,
 13                           java.lang.String[] p_out ){
 14
 15      /*
 16       * the simplest of datatypes -- the String.  If you remember
 17       * the C version with 6 formal parameters, null indicators,
 18       * strlen's, strcpy's and so on -- this is trivial in
 19       * comparision
 20       */
 21
 22      if ( p_in != null ){
 23
 24      System.out.println
 25          ( "The first parameter is " + p_in.toString() );
 26
 27          p_out[0] = p_in.toUpperCase();
 28
 29          System.out.println
 30          ( "Set out parameter to " + p_out[0].toString() );
 31      }
 32  }
 33
 34  private static void show_array_info( oracle.sql.ARRAY p_in )
 35  throws SQLException{
 36
 37      System.out.println( "Array is of type      " +
 38                           p_in.getSQLTypeName() );
 39      System.out.println( "Array is of type code " +
 40                           p_in.getBaseType() );
 41      System.out.println( "Array is of length    " +
 42                           p_in.length() );
 43  }
 44
 45  public static void
 46  pass_str_array( oracle.sql.ARRAY p_in, oracle.sql.ARRAY[] p_out )
 47  throws java.sql.SQLException,IOException{
 48
 49      show_array_info( p_in );
 50      String[] values = (String[])p_in.getArray();
 51
 52      for( int i = 0; i < p_in.length(); i++ )
 53          System.out.println( "p_in["+i+"] = " + values[i] );
 54
 55      Connection conn = new OracleDriver().defaultConnection();
 56      ArrayDescriptor descriptor =
 57         ArrayDescriptor.createDescriptor( p_in.getSQLTypeName(), conn );
 58
 59      p_out[0] = new ARRAY( descriptor, conn, values );
 60
 61  }
 62
 63  public static String return_string(){
 64      return "Hello World";
 65  }
 66
 67  }
 68  /

Java created.

ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> SET serveroutput on size 1000000
ops$tkyte%ORA11GR2> EXEC dbms_java.set_output( 1000000 )

PL/SQL procedure successfully completed.

ops$tkyte%ORA11GR2>
ops$tkyte%ORA11GR2> DECLARE
  2     L_IN                          STRARRAY := STRARRAY ();
  3     L_OUT                         STRARRAY := STRARRAY ();
  4  BEGIN
  5     FOR I IN 1 .. 5
  6     LOOP
  7        L_IN.EXTEND;
  8        L_IN (I) := 'Element ' || I;
  9     END LOOP;
 10
 11     DEMO_PASSING_PKG.PASS (L_IN, L_OUT);
 12
 13     FOR I IN 1 .. L_OUT.COUNT
 14     LOOP
 15        DBMS_OUTPUT.PUT_LINE ('l_out('|| I || ') = ' || L_OUT (I) );
 16     END LOOP;
 17  END;
 18  /
Array is of type      OPS$TKYTE.STRARRAY
Array is of type code 12
Array is of length    5
p_in[0] = Element 1
p_in[1] = Element 2
p_in[2] = Element 3
p_in[3] = Element 4
p_in[4] = Element 5
l_out(1) = Element 1
l_out(2) = Element 2
l_out(3) = Element 3
l_out(4) = Element 4
l_out(5) = Element 5

PL/SQL procedure successfully completed.