DescriptionUse the PL/SQL compile time warnings system to detect when you are using names of pre-defined elements of PL/SQL, such as VARCHAR2, for identifiers in your application. This is best to avoid confusion.
ContributorSteven Feuerstein (Oracle)
CreatedWednesday February 21, 2018
ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'
CREATE OR REPLACE PROCEDURE plw5004 AUTHID DEFINER
INTEGER := 10;
Warning: PROCEDURE PLW5004
Line: 3 PLW-05004: identifier INTEGER is also declared in STANDARD or is a SQL builtin
Line: 5 PLW-05004: identifier TO_CHAR is also declared in STANDARD or is a SQL builtin