[Keith Fetterman]

I tried to execute a SQL script in a MyEclipse SQL editor that had Oracle comments included. The SQL editor would not execute the script.

Can you add the feature to allow the editor to execute the script if the comments are included in a SQL script file “*.sql”. Below is an excerpt from the Oracle SQL Reference manual that talks about comments:

A comment can appear between any keywords, parameters, or punctuation marks in a statement. You can include a comment in a statement using either of these means:

* Begin the comment with a slash and an asterisk (/*). Proceed with the text of the comment. This text can span multiple lines. End the comment with an asterisk and a slash (*/). The opening and terminating characters need not be separated from the text by a space or a line break.
* Begin the comment with — (two hyphens). Proceed with the text of the comment. This text cannot extend to a new line. End the comment with a line break.

A SQL statement can contain multiple comments of both styles. The text of a comment can contain any printable characters in your database character set.

[Riyad Kalla]

Sending this off to our DB dev, thank you for reference.

[support-jeff]

Keith –

Please post the script you are trying to run, and any error logs generated in the .metadata/.log file.

[Author]

Posts