1 Reply Latest reply: Mar 5, 2013 1:57 PM by anandk RSS

    Unable to use custom data types

    Snowy
      I have an ADF application that uses custom data types and when using in the Java Cloud Service, I get the following error:
      Caused by: java.sql.SQLException: ORA-06550: line 1, column 13:
      PLS-00201: identifier 'DBMS_PICKLER' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      It happens when registering the OUT parameter (ie- before it is even executed):
      stmt.registerOutParameter(5, Types.ARRAY, "SSP_NARR_T");
      For reference, this is the definition of my data type:
      CREATE TYPE ssp_narr_t IS TABLE OF NUMBER(15);
      Is this a limitation or a cloud database setup issue?
        • 1. Re: Unable to use custom data types
          anandk
          I apologies for the late response. At this point we do not support custom data types, since it required a particular DB package. And this package in not available in our DB Cloud Service. I would love to hear your use-case. It will help us determine how we can provide this feature.

          Thanks,
          -A.