1 Reply Latest reply on Sep 23, 2016 3:24 PM by Vadim Tropashko-Oracle

    [4.2EA] Code Outline chokes on REGEXP_LIKE with bind value for regex

    Sentinel

      The Code Outline window incorrectly reports a Syntax Error when SQL code contains a bind variable in the 2nd parameter of a regexp_like function (actually anything other than a constant in the 2nd parameter fails to parse):

       

      SELECT * FROM dual WHERE REGEXP_LIKE( dummy, :VALUE );
      

       

      Conversely the following query which does have a syntax error is successfully parsed by the Code Outline window:

       

      SELECT * FROM dual WHERE REGEXP_LIKE( dummy, :VALUE ) = null;
      

       

      regexp_like functions in the where clause are parsed just fine when the second argument is a constant:

       

      SELECT * FROM dual WHERE REGEXP_LIKE( dummy, '' );