Home

Description

The rule "Features deprecated in Oracle 12 should not be used" means that any features that have been deprecated (or removed) in Oracle 12 should not be used in PL/SQL code. This includes any features that have been removed from Oracle 12 or any features that have been marked as deprecated, which means they may be removed in a future version. This rule is important to follow as deprecated features may not work correctly in newer versions of Oracle, and may cause unexpected errors or performance issues.

Key Benefits

• Improved Security: By not using deprecated features, the security of your system is improved as these features may be vulnerable to attack.
• Enhanced Performance: Deprecated features may be inefficient and can slow down the performance of your system. By not using them, you can improve the performance of your system.
• Reduced Maintenance: By not using deprecated features, you can reduce the amount of maintenance needed for your system as these features may require more frequent updates.
• Improved Compatibility: By not using deprecated features, you can ensure that your system is compatible with other systems and applications.

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;