SAP Knowledge Base Article - Preview

3269280 - Invalid procedure EXECASUSERID and EXECASUSER

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.