Parsing SQL text bug

[Mindaugas]

Hello,

Here are two statements:

PROMPT Inserting order's values

after this, because of one quote, the rest of the text is "colored" as string.

PROMPT Inserting order''s values

after this, two quotes, text is "colored" fine.

Maybe it's possbile, after word PROMPT, make parser more intelligent in coloring code text

 

[Marco Kalter]

Which window type are you using? The Command Window displays this correctly. Other windows do not support the PROMPT command (which is a SQL*Plus command).

 

[Mindaugas]

I've used SQL window.
Yes, you are right about supporting PROMPT command.
But I was editing SQL script in SQL window, and because of 1 quote, highlighting was incorrect.