Bernhard S
Member³
Hello,
I have autoselect enabled in preferences and have the following in an SQL-Window:
-------------------------------------------
select 1 from dual; --1st statement
select 2 from dual; --2nd statement
-------------------------------------------
No matter where my pointer is, whenever I try to execute with F8, I get:
Error ORA-00911 invalid character
and the pointer jumps to the semicolon of the current SQL. Without the comments the autoselect works fine. Seems like the comments irritate autoselection.
If I remove the seconde comment and have my SQL-Window filled like this:
-------------------------------------------
select 1 from dual; --1st statement
select 2 from dual;
-------------------------------------------
I get as result always "1", the result of the first SQL, even though my pointer is in the second SQL!
It also doesn't highlight any SQL.
Hope this behaviour gets fixed soon. It's quite irritating.
Best Regards,
Bernhard
I have autoselect enabled in preferences and have the following in an SQL-Window:
-------------------------------------------
select 1 from dual; --1st statement
select 2 from dual; --2nd statement
-------------------------------------------
No matter where my pointer is, whenever I try to execute with F8, I get:
Error ORA-00911 invalid character
and the pointer jumps to the semicolon of the current SQL. Without the comments the autoselect works fine. Seems like the comments irritate autoselection.
If I remove the seconde comment and have my SQL-Window filled like this:
-------------------------------------------
select 1 from dual; --1st statement
select 2 from dual;
-------------------------------------------
I get as result always "1", the result of the first SQL, even though my pointer is in the second SQL!
It also doesn't highlight any SQL.Hope this behaviour gets fixed soon. It's quite irritating.
Best Regards,
Bernhard
