5 Replies Latest reply on Jul 13, 2017 7:02 AM by Patrick Jolliffe

    4.2EA2 Formatter Bug Conditional Compilation (another one)

    Patrick Jolliffe

      declare

          dummy number;

      begin

          select count(*) into dummy  from dual where 1 = 1

          $IF DBMS_DB_VERSION.VER_LE_10 $THEN

              AND 1 = 1

          $ELSIF DBMS_DB_VERSION.VER_LE_11 $THEN

              AND 1 = 1

          $ELSE

              AND 1 = 1

          $END;

      end;

       

      Becomes:

      declare

          dummy number;

      begin

          select count(*) into dummy  from dual where 1 = 1

      /*** Syntax Error at line 3, column 54

       

       

          select count(*) into dummy  from dual where 1 = 1

                                                            ^^^

       

      Expected:

      ***/

          $IF DBMS_DB_VERSION.VER_LE_10 $THEN

              AND 1 = 1

          $ELSIF DBMS_DB_VERSION.VER_LE_11 $THEN

              AND 1 = 1

          $ELSE

              AND 1 = 1

          $END;

      end;