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