Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
11
Views
2
Comments
edited Jan 20, 2018 8:00AM in Java 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!