Show the procedure is marked invalid **
SQL> SQL> COL object_name FORMAT A15 SQL> COL status FORMAT A10 SQL> SQL> SELECT object_name, status FROM user_objects WHERE object_name = 'COMPILEERROR'; OBJECT_NAME STATUS --------------- ---------- COMPILEERROR VALID 1 row selected.