Uploaded image for project: 'SonarPLSQL'
  1. SonarPLSQL
  2. SONARPLSQL-740

Parse error on empty REFERENCING clause in CREATE TRIGGER

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5
    • Component/s: Parser
    • Labels:
      None

      Description

      The PL/SQL analyzer trigger a parsing error on the following code:

      create or replace trigger x
        before insert on y
        referencing
        for each row
      begin
        null;
      end;
      

      According to the documentation for CREATE TRIGGER, the REFERENCING clause cannot be empty.
      However, the code is compiled without any error by Oracle (12c).
      The PL/SQL analyzer should therefore not raise a parsing error in that case.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              amelie.renard Amélie Renard
              Reporter:
              pierre-yves.nicolas Pierre-Yves Nicolas
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: