Live SQL

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

Additional Information

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