Symptoms
Oracle Service instance issue reading Stored Procedure
Diagnoses
When attempting to execute an Oracle Stored Procedure smartobject configured with another user/schema it errors with:
“identifier ‘XXXX’ must be declared” error
Resolution
A documentation TFS item was logged to indicate the necessity for a SYNONYM (public or private) when facing this error. Please see some blogs below regarding the requirement for a SYNONYM:
https://community.oracle.com/thread/315042
https://blogs.oracle.com/mandalika/entry/resolving_pls_00201_identifier_dbms
http://www.dbasupport.com/forums/showthread.php?53493-DBMS_JOB-errors-PLS-00201-identifier-package-proc_name-must-be-declared
