Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Valid Oracle SQL Receives ORA-01742: Comment Not Terminated Properly

user-wpxhgApr 17 2023

When running Oracle SQL against an Oracle 19C database, using the following command triggers an error:

SELECT dummy

/*;

*/

from dual

;

It is essential that the semicolon and end comment (*/) are on separate lines, but more can be added into the query or comment and the error will persist.

This query receives the following error message:
/*
*
ERROR at line 718:
ORA-01742: comment not terminated properly

It appears the VSCode to Oracle tool is getting tripped up by the semicolon in the comment. Placing a character after the semicolon on the same line removes the error.

Comments
Post Details
Added on Apr 17 2023
1 comment
861 views