annoying Ora-911 in SQL-Window

[FrankB]

Hello,
since 7.1.5 the syntax parser in the sql windows does not work as before:

if you have three statements with comments an the window an press F8 while first row ist marked, you get a syntax error

select ID from TABLE1 GROUP BY id; -- remark1
select x from table2 GROUP BY x; -- remark2

if you remove the comment or move the comment to a new line, the syntax will be good again

if you mark the second line and press f8, this and the following sql-phrase will be marked and ora911 will be raised

it is irrelevant if -- or /* */ will be used for comments

Moving the ending ';' of each clause behind each comment will help too. So i assume that there is a bad parsing error.

This is very annoying but has worked well before.

Regards,
Frank

 

[Marco Kalter]

This is indeed not right. We'll fix it.

 

[Gustavo]

Indeed, I had faced some parsing issues before with "autoselect statement", but it got worse in 7.1.5.

 

[FrankB]

hotfix plsqldev715.1397.exe seem to work well again

@Marco: Would you be so kind and submit us some informations about what was fixed with this build?

Thanks,
Frank

 

[Marco Kalter]

It will be published today. Only this 7.1.5 specific bug was fixed though, as well as an issue with a deprecated compilation flag in 11g.