This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,876 Users
  • 2,269,775 Discussions


Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed

3405925 Member Posts: 5
edited Jan 20, 2018 7:26AM in Java Cloud Service


We have deployed one custom ADF application on JCS SaaS instance. Which call procedure having in and parameter. Some of the parameters uses custom data types.

When we run in JCS SaaS getting below error:

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 IN and OUT parameter

ArrayDescriptor inputArrayCollection =ArrayDescriptor.createDescriptor("DRIVER_RULE_VALUES", conn);

ArrayDescriptor inputArrayCollection1 =ArrayDescriptor.createDescriptor("DRIVER_RULE_VALUES", conn);

ArrayDescriptor outputArrayCollection =ArrayDescriptor.createDescriptor("RULE_VALUES", conn);




  • oladayo.s
    oladayo.s Member Posts: 48 Blue Ribbon
    edited Jan 15, 2018 1:26AM

    Hello, JCS SaaS Instance uses the database schema service which may not necessarily have all the features of an enterprise database. It seems you may require some sort of custom type in your database schema which is missing. If you can verify that the database objects required for your arraydescriptors object all exist then this should work. Otherwise it is one of the limitations of the db schema service i.e. creation of custom types. Contact jcs support to verify what the limitations of the database instance are.

  • Vikash Mishra-Oracle
    Vikash Mishra-Oracle Member Posts: 61
    edited Jan 20, 2018 7:26AM


    'DBMS_PICKLER' is NOT supported in Schema db (Apex).


    Vikash Mishra

This discussion has been closed.