Avoid Using Pre-Defined Names

View All Scripts Login to Run Script

Script Name Avoid Using Pre-Defined Names
Description Use 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.
Area PL/SQL General
Contributor Steven Feuerstein
Created Wednesday February 21, 2018

Statement 1

ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'

Statement processed.

Statement 2

CREATE OR REPLACE PROCEDURE plw5004 AUTHID DEFINER 
IS 
   INTEGER   NUMBER; 
 
   PROCEDURE TO_CHAR 
   IS 
   BEGIN 
      INTEGER := 10; 
   END TO_CHAR; 
BEGIN 
   TO_CHAR; 
END plw5004;

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

More Details: https://docs.oracle.com/error-help/db/ora-20001

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database