Mismatch of the Element Name and the DEPRECATE Pragma Argument

View All Scripts Login to Run Script

Script Name Mismatch of the Element Name and the DEPRECATE Pragma Argument
Description This example shows that if the argument for the pragma does not match the name in the declaration, the pragma is ignored and the compiler does not issue a warning.
Area PL/SQL General
Referenced In Database PL/SQL Language Reference
Contributor Sarah Hirschfeld (Oracle)
Created Monday January 09, 2017

Statement 1

ALTER SESSION SET PLSQL_WARNINGS='ENABLE:(6019,6020,6021,6022)'

Statement processed.

Statement 2

A quoted identifier is applied with a mismatched name. The compiler does not issue a warning. The pragma has no effect.

CREATE OR REPLACE PACKAGE pkg13  
AS  
  PRAGMA DEPRECATE ('pkg13', 'Package pkg13 is deprecated, use pkg03');  
  Y NUMBER;  
END pkg13;

Package created.

Statement 3

Do not quote the identifier. The default name resolution will match with the package name.

CREATE OR REPLACE PACKAGE pkg13     
AS     
  PRAGMA DEPRECATE (PKG13, 'Package pkg13 is deprecated, use pkg03');     
  Y NUMBER;     
END pkg13;

Warning: PACKAGE PKG13
Line: 3 PLW-06019: entity PKG13 is deprecated

Statement 4

SELECT * FROM USER_ERRORS


NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
PKG13 PACKAGE 1 3 3 PLW-06019: entity PKG13 is deprecated WARNING 6019

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
PKG13	PACKAGE	1	3	3	PLW-06019: entity PKG13 is deprecated	WARNING	6019

Additional Information