Trying to Correct All Invalid Objects and AP_WEB_ARCHIVE_PURGE_ER Package Body is Invalid
Hi,
Object AP_WEB_ARCHIVE_PURGE_ER is invalid in production(CEN01) and we are in process of making zero invalid.
SQL> select line,text from user_errors where name='AP_WEB_ARCHIVE_PURGE_ER';
LINE
----------
TEXT
--------------------------------------------------------------------------------
200
PL/SQL: ORA-00947: not enough values
200
PL/SQL: SQL Statement ignored
But spec is in valid state when we see from dba_objects and only body is invalid.
Thanks
Object AP_WEB_ARCHIVE_PURGE_ER is invalid in production(CEN01) and we are in process of making zero invalid.
SQL> select line,text from user_errors where name='AP_WEB_ARCHIVE_PURGE_ER';
LINE
----------
TEXT
--------------------------------------------------------------------------------
200
PL/SQL: ORA-00947: not enough values
200
PL/SQL: SQL Statement ignored
But spec is in valid state when we see from dba_objects and only body is invalid.
Thanks
Tagged:
0