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.7Information 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