Home

Features deprecated in Oracle 12 should not be used

Rule description

  • Features deprecated in Oracle 12 should not be used

 

Non-compliant Code Example

BEGIN 
    V$OBJECT_USAGE('CUSTOMER_INDEX','CUSTOMER_TABLE');                      --Non compliant code (Features deprecated in Oracle 12 are used)
    ALL_SCHEDULER_CREDENTIALS('DemoRule','Update','DeprecatedFeatures');    --Non compliant code (Features deprecated in Oracle 12 are used)
    DBA_SCHEDULER_CREDENTIALS('DemoRule','Update','DeprecatedFeatures');    --Non compliant code (Features deprecated in Oracle 12 are used)
    USER_SCHEDULER_CREDENTIALS('DemoRule','Update','DeprecatedFeatures');   --Non compliant code (Features deprecated in Oracle 12 are used)
    DBMS_DDL.ALTER_COMPILE('TRIGGER','DBO','DeprecatedFeatures');	        --Non compliant code (Features deprecated in Oracle 12 are used)
    DBA_NETWORK_ACL_PRIVILEGES('acl');                                      --Non compliant code (Features deprecated in Oracle 12 are used)
    DBA_NETWORK_ACLS('192.168.0.192');                                      --Non compliant code (Features deprecated in Oracle 12 are used)
    USER_NETWORK_ACL_PRIVILEGES();                                          --Non compliant code (Features deprecated in Oracle 12 are used)
END;
Visual Expert 2020
 VEPLSQLRULE149