Toad World® Forums

Problem with comment


#1

this statement

select * from dual where dummy = ‘X’ /* comment here */ ;

gives you
12:38:50 PM ORA-01742: comment not terminated properly

this
select * from dual where dummy = ‘X’ ; /* comment here */ ;

gives you:

12:40:47 PM ORA-00911: invalid character

Jet
Message was edited by: joethejet


#2

Hi Joe,

Thanks for the feedbacks. We 're going to fix the first issue where multi-line comment is found before the semi-colon. The statement should be executed as normal.

Regarding the second case, although the statement runs in 5.5 we don’t support multi-statements on one line so it’s reasonable to leave this ‘feature’ out.

Gwen


#3

Sorry, the browser isn’t formatting things correctly.

It should be:

select * from dual where dummy = ‘X’ ;

/* comment here */ ;

And I put my cursor on the first line. I believe this should work


#4

Hi Joe,

I will raise a CR for this. It’s not an urgent issue so it will be investigated in later releases.

Gwen