Home

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;