Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Syntax highlighting & Query pane issue

User_C7VVAJul 10 2021

Hello,
I am having a weird bug as the syntax highlighting is missing in my queries for the JOIN keyword.
If I use the Language PL/SQL extension with 'PLSQL' as language for the files, then it works but I cannot run the queries using ODT.
To run queries with ODT, I need to change the language to 'Oracle-SQL and PLSQL' but then I have this issue in my queries.
Any help ?

image.png

Also, after running a query, the results pane is hidden and I have to scroll every time.
Is this a bug ? Is there a way to fix the layout to get the results directly ?
Thank you,

Comments

Hi,
To confirm is the issue strictly with the syntax highlighting, or do you have errors when you execute it?
As for the results, I am not sure what you mean. Are you saying that there are existing output that you have to scroll though?
If so, you can use the setting Oracledevtools › Query: Clear Results Window to clear the results each time.
If you want to change the layout of your screen, you can try this:
In the VS Code menu, select View->Editor Layout->Two Rows.
Execute some SQL or PL/SQL
Drag the SQL results tab into the lower pane.
Please let me know more details of your problems if these do not fix it.

User_C7VVA

Hello Christian,
Thank you for your answers.

  1. There are no errors when I execute the queries... So it is only related to syntax highlighting.

  2. I changed the layout to two rows, and I used 'Clear Results Window' but I have the same issue, see below.
    With a very short query, it looks like this, results are seen directly:
    image.png
    With a longer query, query is shown first and results are hidden (even if there is only a row)
    Focus is on the query that ran, but I believe it should be on the results.
    image.pngAnd I have to scroll every time to see the results:
    image.png

Christian.Shay -Oracle

Hi,
I believe we have fixed the syntax highlighting bug in the next release. When the next version comes out, please give it a try.
As for being forced to scroll, can you try turning off ECHO so that the SQL statement is not sent to the output? With that setting and automatically clearing results, then you will not have to scroll.
In the settings, uncheck Oracledevtools › Query: Echo
and also check Oracledevtools › Query: Clear Results Window
Let me know how that goes....

User_C7VVA

OK, understood for the highlighting, I will check it in the next version.
When echo is off, and clear results window is on, I have the desired layout, centered on the results. I will use this setup, thank you.
When echo is off, and clear results is off, after 3/4 executions, the results fill the screen and I have to scroll. It could be interesting to see the previous executions and to have the window centered on the last one at the same time.

Ok, got it. I will include "auto scroll output to last result" in our feature request list.

User_C7VVA

Great, thank you !

This issue with scrolling properly to see the last result should be fixed in 21.3.0. Please try it out and let me know.

User_C7VVA

It's fixed!

1 - 8

Post Details

Added on Jul 10 2021
8 comments
415 views