Beautifier: Quoted Strings and Compiler Directives

[Scott Eli]

The beautifier does not know how to deal with quoted strings

Q'(Aren't quoted strings great?)'

or with conditional compilation directives

$IF boolean_static_expression $THEN text
  [ $ELSIF boolean_static_expression $THEN text ]
  [ $ELSE text ]
$END

Will these be supported soon?

 

[Marco Kalter]

Yes, this is on the list of enhancement requests.

 

[Scott Eli]

We just upgraded to 7.0.1. Quoted Strings and Compiler directives still not supported by the Beautifier.

In fact, we can't use quoted strings and the beautifier because it changes quoted strings so they won't compile by putting a space between the Q and the quote.

Also, for some reason the beautifier does this with the 'end case' statement:

else
                  null;
            end case; end loop;

 

[Marco Kalter]

This should be fixed in the upcoming 7.0.2 release.

 

[fraenkg]

It seems to be fixed by changing kwf- files.

But, if using these new definition, all stetements in my pl/sql are colored as string after seting a variable to e.g. '(' until ')' is found. Even if i can't use new 10g syntax - still using previous versions.

1 fs := '(';
2 fn := 2;
3 fs := fs || ')';
4 fn := 3;

In above example lines 2 and 3 are highlighted as string.

regards
frank