comment on code line in command window

MartinF

Member²
Hi,
I am using PLSQL Dev 9.0.6.1665 and I just notice something strange in command window.

Here is some sample code to reproduce the problem.
Open a command window and create the following table.

Code:
create table test_mfa(col_1 number,col_2 varchar2(100),col_3 date);
insert into test_mfa values(1,'a',sysdate);

Now you run an update command that contain comment at the end of each line

SQL:
SQL> update test_mfa --line 1
  2  set col_1 = 2 --line 2
  3  where col_2 = 'a'; --line 3

update test_mfa --line 1
set col_1 = 2 --line 2
where col_2 = 'a'; --line

ORA-00911: invalid character

SQL> update test_mfa --line 1
  2  set col_1 = 2 --line 2
  3  where col_2 = 'a' --line 3;

1 row updated

SQL>

If I put the symbol ';' before the comment, I am getting and error but if I put it after the comment it worked ???

Is it a bug?

Regards,

Martin
 
Back
Top