Live SQL

Misplaced DEPRECATE Pragma

View All Scripts Login to Run Script

Script Name Misplaced DEPRECATE Pragma
Description The DEPRECATE pragma must appear immediately after the declaration of the deprecated item. A warning about the misplaced pragma is issued and the pragma has no effect.
Area PL/SQL General
Referenced In Database PL/SQL Language Reference
Contributor Sarah Hirschfeld (Oracle)
Created Friday January 06, 2017

Statement 1

Enable the Deprecation Warnings

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

Statement processed.

Statement 2
A PLW-06021 warning about the misplaced pragma is issued and the pragma has no effect.The pragma DEPRECATE should follow immediately after the declaration of the entity that is being deprecated.
```
CREATE OR REPLACE PROCEDURE bar 
IS 
BEGIN 
   PRAGMA DEPRECATE(bar); 
   DBMS_OUTPUT.PUT_LINE('Executing bar.'); 
END; 
```
```
Warning: PROCEDURE BAR
Line: 4 PLW-06021: PRAGMA DEPRECATE on BAR is misplaced
```
More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 3

Place the pragma immediately after the declaration of the entity that is being deprecated.

CREATE OR REPLACE PROCEDURE bar  
IS  
   PRAGMA DEPRECATE(bar);  
BEGIN  
   DBMS_OUTPUT.PUT_LINE('Executing bar.');  
END;

Warning: PROCEDURE BAR
Line: 3 PLW-06019: entity BAR is deprecated

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

Statement 4
If an identifier is applied with a mismatched name, then the compiler issues a warning about the pragma being misplaced. The pragma has no effect.
```
CREATE OR REPLACE PACKAGE pkg17   
IS   
  PRAGMA DEPRECATE ("pkg17");   
END pkg17;
```
```
Warning: PACKAGE PKG17
Line: 3 PLW-06021: PRAGMA DEPRECATE on pkg17 is misplaced
```
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