Details

    • Type: Language-Specification
    • Status: Active
    • Resolution: Unresolved
    • Labels:
      None
    • Impact:
      Unknown 'null' severity
    • Likelihood:
      Unknown 'null' severity
    • Legacy Key:
      DeadCodeCheck
    • Remediation Function:
      Constant/Issue
    • Constant Cost:
      30min

      Description

      Jump statements (EXIT, CONTINUE, RETURN, RAISE, and RAISE_APPLICATION_ERROR), move control flow out of the current code block. So any statements that come after a jump are dead code.

      This rule detects for statements that follow:

      • EXIT without a WHEN
      • CONTINUE without a WHEN
      • RETURN
      • RAISE
      • RAISE_APPLICATION_ERROR

      Noncompliant Code Example

      SET SERVEROUTPUT ON
      
      BEGIN
        LOOP
          DBMS_OUTPUT.PUT_LINE('This will be printed out');
          EXIT;
      
          DBMS_OUTPUT.PUT_LINE('This will NEVER be printed out'); -- Non-Compliant
        END LOOP;
      END;
      /
      

      Compliant Solution

      SET SERVEROUTPUT ON
      
      BEGIN
        LOOP
          DBMS_OUTPUT.PUT_LINE('This will be printed out');
          EXIT;
        END LOOP;
      END;
      /
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ann.campbell.2 Ann Campbell
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: