VS Code - Syntax Highlighting Conflict

User_5SHPU

Hello

Is there a way to turn off ODT for VS Code's native syntax highlighting?

The theme I'm using should display SQL as shown below (note the grey-blue of column names, aliases, table names etc, and the light blue for recognised functions like Count():

When I have the ODT for VS Code extension turned on, it seems to override some of my selected theme's syntax highlighting and leaving the aforemention bits of text white:

Other than enabling/disabling the extension, I can't see a way to stop this.

Thanks, Matt.

Christian.Shay -Oracle

Hi Matt,

There's currently no setting to disable syntax coloring. You could click the Oracle-SQL and PL/SQL language mode at the bottom in the status bar and temporarily associate the file with a text editor if a patch of text is messing you up, but I realize that is not a very good solution.

What theme are you using?

User_5SHPU

Thanks Christian. I'm using the Better_JS theme (I've adapted a couple of colours here and there).

Christian.Shay -Oracle

Hi,

I was a bit distressed by your situation 😯 so I did some googling. I found this long github thread about themes per language:

https://github.com/microsoft/vscode/issues/20652

..and it seemed to be resolved by this extension:

https://marketplace.visualstudio.com/items?itemName=jsaulou.theme-by-language

While not the perfect solution, maybe you can use it to choose a different (or tweaked) theme just for our extension that looks better given our syntax coloring choices.

If you decide to try this, can you please let me know if it helps?

User_5SHPU

Thanks for digging that out.

I ran the the following commands for the Theme by Language extension you linked me to:

Clear all registered custom themes for file languages

Set theme for current file language > Better_JS

But unfortunately the ODT's formatting still seems to take precedence for certain parts of the code and formatting text as white:

User_5SHPU

Is the formatting specified in one of the ODT files... perhaps I could just change it to match the theme I use (I don't tend to use others ones at the moment).

Christian.Shay -Oracle

https://community.oracle.com/tech/developers/discussion/comment/16793534#Comment_16793534

It is true that we will force different colors as we highlight, but what I meant for you to do is to use a different theme than Better_JS or a customized version of that theme just for our extensions where you you find there are no conflicts or the color scheme is acceptable to your eyes. Maybe you can try various themes with our extension and find one where our colorization choices don't hurt your eyes? (That may not exist of course 😯)

User_5SHPU

Oh I see, my apologies - find a theme that harmonizes well with ODT's syntax highlighting.

TBH, I can live with the white text, just would prefer to be able to use the selected theme's colours (i.e. have the option to turn off ODT's syntax highlighting colours).

Thanks for taking a look at this for me 🙂

Christian.Shay -Oracle

Right, and please note that in other themes, we do not use white (for example, default dark).

So there may be a tweak to the background color that you can do that changes our color, etc. It will take some experimentation.

I will add this setting to a list of feature requests I am maintaining and hopefully we can address it in a future release.