Error: ORA-00900: invalid SQL statement AutoSelect statement Comment

Code (Used to be longer but I deleted everything that didn't make the error disappear):
/*
*/
SELECT 1 FROM dual;
--
SELECT 1 FROM dual;


I have the cursor in the 2nd SQL statement and use F8 to execute it.

I have the option "AutoSelect statement" checked and it looks like it selects more than just the SQL statement but also the comment before but not entirely (just one of the dashes).
See in the picture:


The thing is - it happens only sometimes - more than once per day. I reopen the file and keep working with it like nothing happened - no errors.

I just switched from 11.0.6.1776 to 12.0.3.1821. On 11 it happened not very often - once per week. But on 12 it is too often to tolerate.

I cannot immediately reproduce this. We'll investigate.

Yes, unfortunately I haven't got a solid test scenario.

Usually the files I work with are about 300 - 1000 lines with several comments, SQLs and anonymous plsql blocks.

I have also the same problem. A lot of times (but i cannot reproduce it) it seems like the autoselect is shifted one character to the right.

For example, a couple of minutes ago I had these statements:

COMMIT;

SELECT period, COUNT(1)
from livload.udm_mob_liuos a
GROUP BY period;

I put the cursor over the word count and the statement that was executed (and highlighted) was

ELECT period, COUNT(1)
from livload.udm_mob_liuos a
GROUP BY period;

The highlighted text was extended to the first character of the empty row, exactly below of the statement.

I'll upload a screenshot as soon as this happens again, for sure several times a day. If I save the file and re-open it, the problem disappears, as well as if I copy the whole stuff to a new SQL Window

Aris

Here is an image that demonstrates the error :

[Linked Image]

Yes, today I had the same problem even when there was no "--" cooment before my SQL. It just took the statement without the first character " S". Just like Arky said.

This problem is annoying me every day, every hour. Please hurry

Today I got the same error when there was no comment involved at all. It just omitted the "SELEC" part of "SELECT":
[img]https://imgur.com/a/i50IN[/img]
https://imgur.com/a/i50IN

Adding images to posts is a pain in the ass

Just a hint: Maybe it is somehow related to window type switching. I'm using "Change Window to" > Program Window, Command Window, SQL window.
Not exactly with the file I'm having problems, but with other opened files.

Only solution - workaround so far:

Ctrl-A
Ctrl-X
Ctrl-V

(it works..)