user defined data types

[mohammadiz]

Hi
how can I pass a user defined type or array of user defined type to a function?

type:
CREATE TYPE CARDDATARECTYPE AS (DATANAME VARCHAR(256), DATAVALUE VARCHAR(2048), ISDELETABLE SMALLINT )

By oracle jdbc I do this by following:

StructDescriptor cardStruct = StructDescriptor.createDescriptor("CARDDATARECTYPE",stmt.getConnection());
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("CARDDATARECARRAY",stmt.getConnection());
Object[] arr = new Object[datas.length];
for (int i = 0; i < this.datas.length; i++) {
  Object[] cardData = {datas[i].getName(), datas[i].getValue(), (datas[i].getDeletable() ? "1" : "0")};
        STRUCT p1struct = new STRUCT(cardStruct, stmt.getConnection(), cardData);
        arr[i] = p1struct;
      }
      ARRAY oraArr = new oracle.sql.ARRAY(desc, stmt.getConnection(), arr);
      stmt.setObject(13, oraArr, oracle.jdbc.driver.OracleTypes.ARRAY);
 

thanks alot