Oracle Records and registerOutParameter?

Hello,

I want to call a stored function that returns an oracle record. When I try this using the code below, I get

 Invalid column type: get_internal_type

when calling *registerOutputParameter(1, Types.OTHER)* of the CallableStatement. Does anybody know how this is to be done?

Here's my code:

Oracle:

      create or replace package pkg_test
      as

        type t_rec is record
        (
          m_Id    integer,
          m_Text  char(10)
        );

        function func_rec
        return t_rec;

        pragma restrict_references(func_rec, RNDS, WNDS);

      end pkg_test;

Java:

      Connection        fv_Con;
      CallableStatement fv_CallStmt;
      oracle.sql.STRUCT fv_OraStruct;

      fv_CallStmt = fv_Con.prepareCall("begin :1 := pkg_test.func_rec(); end;");

      fv_CallStmt.registerOutParameter(1,Types.OTHER); <- exception occurs at this point

      fv_CallStmt.execute();
      fv_OraStruct = (oracle.sql.STRUCT)fv_CallStmt.getObject(1);

Thanks for any hint,

Werner Ebert Received on Tue Nov 23 1999 - 09:17:33 CST