Symptom
Invalid procedure, for example:
OWNER OBJECT_TYPE OBJECT_NAME
-------------------- ----------------------- ------------------------------
SYS PROCEDURE EXECASUSERID
SYS PROCEDURE EXECASUSER
Manually compile shows:
SQL> ALTER PROCEDURE sys.EXECASUSERID COMPILE;
Warning: Procedure altered with compilation errors.
SQL> show error
Errors for PROCEDURE SYS.EXECASUSERID:
LINE/COL ERROR
-------- -----------------------------------------------------------------
32/11 PL/SQL: Statement ignored
33/48 PLS-00302: component 'ERR_BAD_DDL' must be declared
39/12 PL/SQL: Statement ignored
39/31 PLS-00302: component 'CHECKCATALOGSYSLINK' must be declared
63/11 PL/SQL: Statement ignored
64/48 PLS-00302: component 'ERR_BAD_DDL' must be declared
SQL> ALTER PROCEDURE sys.EXECASUSER COMPILE;
Warning: Procedure altered with compilation errors.
SQL> show error
Errors for PROCEDURE SYS.EXECASUSER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
26/5 PL/SQL: Statement ignored
26/5 PLS-00905: object SYS.EXECASUSERID is invalid
SQL> show errors
Errors for PROCEDURE SYS.EXECASUSER:
Read more...
Environment
Oracle
Keywords
EXECASUSERID, EXECASUSER , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.