Invalid Pl/Sql Procedures Are Not Producing Any Errors (Doc ID 358522.1)

Last updated on MARCH 04, 2022

Applies to:

Symptoms

When developing PL/SQL programs in SQL*Plus that contain errors the database is not reporting these errors.

Here is a simple example:

SQL> create or replace procedure simple
2 as
3 begin
4 ull;
5 end;
6 /

Procedure created. <======This should be producing an error.

SQL> show errors
No errors.
SQL> exec simple
BEGIN simple; END;

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SCOTT.SIMPLE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



This is the expected error to be displayed when doing a "show error"

SQL> show error
Errors for PROCEDURE SIMPLE:

LINE/COL ERROR
-------- ------------------------------------------------
4/1 PLS-00201: identifier 'ULL' must be declared
4/1 PL/SQL: Statement ignored
SQL>

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.