/* */ Comment on sql-script

[ed10k]

My sql-script is:

You must enter a space after the slash-asterisk(/*) beginning a comment, otherwise
the comment is treated as a command, and the slash is interpreted as an execute
command, executing any command in the SQL*Plus buffer.

 

[Marco Kalter]

What exactly is the question?

 

[ed10k]

If you insert a space after /*

/* PROMPT Now
select sysdate from dual
;
*/

then the syntax error at sqlplus goes away.
I don't known the best solution of this.
Perhaps you schould always insert a space after /*.
Comment on this from members of this forum are welcome.

 

[ScottMattes]

don't use sql/plus! The SQL Window gives an ORA-00900 when you try to execute with no statement.

 

[ed10k]

don't use sql/plus!

I have to use sqlplus!

I work on a big project. The sql-scripts are supplied to operating-team and they deploy them to production with sqlplus.