1 Reply Latest reply on Oct 3, 2016 3:57 PM by Vadim Tropashko-Oracle

    [42EA] Formatter Bug (REGEXP_LIKE)

    Patrick Jolliffe

      Managed to simplify as much as possible,  Of course now block doesn't make really sense, however it does execute, but formatter doesn't handle.

       

      DECLARE 

         V VARCHAR2(1024); 

      BEGIN       

         SELECT dummy INTO V FROM dual where REGEXP_LIKE(dummy, L_VARIABLE);

      END;    

       

       

      DECLARE 

         V VARCHAR2(1024); 

      BEGIN       

         SELECT dummy INTO V FROM dual where REGEXP_LIKE(dummy, L_VARIABLE)

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

       

       

         SELECT dummy INTO V FROM dual where REGEXP_LIKE(dummy, L_VARIABLE);

                                                                            ^^^

       

      Expected:

      ***/;

      END;