issue with stored procedure invocation — 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

issue with stored procedure invocation

edited Jul 5, 2024 6:26AM in Integration 7 comments

Summary:

We are trying to call a same stored procedure from two different schema.But from one schema it is working fine and from another schema it is failing.Please let me know why it is failing.

Content (please ensure you mask any confidential information):

Stored procedure invocation error.
Error while trying to prepare and execute the CRPDTA.AS400_TO_PLSQL_INT_PKG.P_PROCESS_EDI_855 API.
An error occurred while preparing and executing the CRPDTA.AS400_TO_PLSQL_INT_PKG.P_PROCESS_EDI_855 API. Cause: java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00302: component 'AS400_TO_PLSQL_INT_PKG' must be declared

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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