Warning 755 - Identifier Data Cannot Be Altered, Found In USER_ERRORS Table After Compiling A Package (Doc ID 1346620.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

PL/SQL warnings have been disabled.

SQL> ALTER SYSTEM SET PLSQL_WARNINGS='DISABLE:ALL';

SQL> show parameter warnings

NAME            TYPE        VALUE
--------------- ----------- ------------------------------
plsql_warnings  string      DISABLE:ALL


You compile a custom PL/SQL package.

SQL> ALTER PACKAGE my_package COMPILE;
Package altered.

SQL> ALTER PACKAGE my_package COMPILE BODY;
Package body altered.


It compiles successfully, but when you check the USER_ERRORS table you see unreported Warnings.

SQL> SELECT * FROM user_errors

NAME        TYPE          SEQUENCE  LINE  POSITION  TEXT                               ATTRIBUTE  MESSAGE_NUMBER
----------- ------------- --------- ----- --------- ---------------------------------- ---------- ---------------
my_package  PACKAGE       1         1     1         Identifier data cannot be altered  WARNING    755
my_package  PACKAGE BODY  1         1     1         Identifier data cannot be altered  WARNING    755

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms