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