My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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.