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

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