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.
SAP Knowledge Base Article - Preview