My Oracle Support Banner

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

Last updated on OCTOBER 23, 2019

Applies to:

PL/SQL - Version 10.2.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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