Syntax highlighting issue with some weird Oracle behaviour

[aotte]

Hi,

I go to maintain some old code, and noticed something weird, or at least something that I didn't know

The code below is valid and executes, even though the string is split across multiple lines.

CREATE OR REPLACE PROCEDURE
   you_re_kidding
AUTHID CURRENT_USER
IS

BEGIN
   EXECUTE IMMEDIATE
   ('CREATE
    TABLE this_is_weird
    AS SELECT *
    FROM dual');
END;

Anyway, the syntax highlighting doesn't mark anything after the CREATE as being a string, and starts marking the

);

at the closing single quote as the start of a string again.

Using:
PL/SQL Developer 5.1.3.704
OCI: Version 8.1
Oracle9i Release 9.2.0.3.0

------------------
Hakuna Matata,

Arnoud.

 

[Marco Kalter]

If you download the mlskwf51.zip file from our web site, and unzip the included keyword files into your PL/SQL Developer installation directory, the multi-line strings will be highlighted correctly.

------------------
Marco Kalter
Allround Automations

 

[aotte]

Works like a charm.

Thanks.

------------------
Hakuna Matata,

Arnoud.

 

[MarkP]

Thank you both.

I had not considered before how much more helpful it would be if long strings did not lose their colour.

Kind Regards, Mark.