Syntax highlighting & Query pane issue

User_C7VVA

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 ?

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,

Christian.Shay -Oracle

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:

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.

And I have to scroll every time to see the results:

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.

Christian.Shay -Oracle

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

User_C7VVA

Great, thank you !

Christian.Shay -Oracle

https://community.oracle.com/tech/developers/discussion/comment/16803293#Comment_16803293

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!