Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3405925Jan 11 2018 — edited Jan 20 2018

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2018

Added on Jan 11 2018

#java-cloud-service

2 comments

1,803 views