Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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.