Home

MLSLABEL should not be used

Description

    The rule "MLSLABEL should not be used" states that the PL/SQL code should not use the MLSLABEL keyword. This keyword is used to identify a label in the source code, which can be used to control the flow of the program. Instead, other methods such as IF-THEN-ELSE or CASE statements should be used to control the flow of the program. Using MLSLABEL can lead to unexpected results and should be avoided.

Key Benefits

  • No Unnecessary Costs: MLSLABEL should not be used to avoid unnecessary costs associated with the implementation of the rule.
  • No Unnecessary Complexity: MLSLABEL should not be used to avoid unnecessary complexity associated with the implementation of the rule.
  • No Unnecessary Risk: MLSLABEL should not be used to avoid unnecessary risk associated with the implementation of the rule.

 

Non-compliant Code Example

CREATE TABLE mls_example
(
id NUMBER,
label_desc MLSLABEL         --Non compliant code (MLSLABEL is used)
);
Visual Expert 2024
 VEPLSQLRULE57