Bug: semicolon gets interpreted despite block comment in sql window

[Bernhard S]

I noticed the following bug. The first sql results in the error noted, obviously due to wrongly interpreting the semicolon as a sql terminator, despite it being enclosed in a block comment:

select 1
  from dual
 where 1 in
/*
;  --=>ORA-01742: comment not terminated properly
*/
 (1);

If you put the same block comment in one line, the error is avoided:

select 1
  from dual
 where 1 in
/* ; */  --works fine
 (1);

In a PSD command window both queries work fine.

 

[Claus Pedersen]

Sounds like this error could be related to a similar parsing error reported in the post:
Block comments in test window are not recognised by "Scan source for variables" button

What do you think, Marco?

 

[Marco Kalter]

This is indeed a known issue.

 

[Claus Pedersen]

Will this be solved in version 10?

 

[Marco Kalter]

This is on the to-do list for the final 10.0 release.

 

[Claus Pedersen]

Super

 

[Claus Pedersen]

This seems to be solved in beta 5.