Syntax highlighting issue ...

[rbrooker]

Hi,

This has been bugging me a while and I have just figured it out.

DECLARE
    v_sql VARCHAR2(1000);
BEGIN
    v_sql := q'[one ' || ' ( ' || 'two' ||  ' ) ' three]';
    dbms_output.put_line(v_sql);
    v_sql := q'[one ' || '( ' || 'two' ||  ' )' three]';
    dbms_output.put_line(v_sql);
END;

Note the spacing around the round brackets in the second assignment to v_sql. )' is acting as a comment end and is breaking the highlighting.

 

[Marco Kalter]

This is indeed a known syntax highlighting issue. We're looking into it.