Java

Get Involved. Join the Conversation.

Topic

    Vaibhav Patil
    Getting Error PLS-00201: identifier 'DBMS_PICKLER'...
    Topic posted January 11, 2018 by Vaibhav Patil, last edited January 20, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged ADF, Cloud, Database, PaaS 
    680 Views, 2 Comments
    Title:
    Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed on JCS SaaS
    Summary:
    Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed on JCS SaaS
    Content:

    Hello,

     

    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);

     

    Thanks,

    Vaibhav

    Comment

     

    • Oladayo Salawu

      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 K Mishra

      Hi,

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

      Regards

      Vikash Mishra