Code colors, it looks like comments

Toad for Oracle - Beta
1

Using the latest beta version of Oracle, I've noticed for quite some time that the code colors sometimes look odd. I've attached a screenshot and a code example for you to replicate.

There are more instances, but it's difficult for me to find them right now.

toad-color-code
toad-color-code908×486 21.2 KB

code-ej.sql (665 Bytes)

Toad for Oracle Base Edition (64-bit)
Add-Ons:
26.2.189.8776

2

Hi Carlos,

You can change the colors of each element here. Foreground is the text color.

image
image842×651 35.5 KB

-John

3

Hi John
the same code should look like this:

toad-color-code--OK
toad-color-code--OK1347×345 24.2 KB

The problem isn't the green color. In this case, the green color indicates that, starting with "q'|", it's being visually interpreted as text.

To make it look correct, you need to change the "|" character to the "{}" character:

  • Command WITH display problems: q'|.....|'
  • Command WITHOUT display problems: q'{.....}'

With that change, it looks fine visually.

Note: The command q'<character> ..... <character>' doesn't have to be {}; it can be any character allowed by Oracle.

4

ok, I see what you mean now.

I will investigate this tomorrow.

Thanks

5

I haven't looked at the edit component source yet, but it looks like the | character could be triggering its symbol highlighting, or at the very least causing it to break out of its q-quote parsing.

I will take a look at it, but it's unlikely it will be fixed for Toad 2026 R2 as we're quickly approaching the end of our dev cycle.

Michael