Semicolons inside commented sections

[DougB]

I've found that semicolons inside commented sections using the /* */ comment will cause semicolons to be recognized and PL/SQL Dev will attempt to parse the sql even though it's commented out. This always results in an ora-01742 comment not terminated properly, and it only occurs if you don't end the original sql with a semicolon.

For instance, this SQL run in a SQL Window:

select * from dual

/*
select *
from dual;
*/

Throws an error, but this does not:

select * from dual;

/*
select *
from dual;
*/

The commented semicolon has to be at the end of a line too - the following doesn't throw an error:

select * from dual

/*;
select *
from; dual
;*/

I'm assuming this isn't intentional, hence my post.

This is on win7, pl/sql dev version 9.0.3.1641

 

[Marco Kalter]

We'll fix it.

 

[Gustavo]

I've reported this before. It looks like it is the same in SQL*Plus.