Script works in SQL*Plus, but not Command Window

[MjH]

We recently ran into a situation where a script containing the command:

ALTER TABLE TABLE_NAME
ADD (
NEW_COLUMN_1 VARCHAR2(100),
NEW_COLUMN_2 VARCHAR2(100),
NEW_COLUMN_3 VARCHAR2(100),
NEW_COLUMN_4 VARCHAR2(100)
)
/

Did not add the new columns to the table, but no error was reported.

It turns out the two spaces before the "/" in the script caused the problem. If the "/" is the first character in the line, then it works.

The script, as is, works from SQL*Plus. Could this be looked at and fixed?

Thanks, Maury

 

[MjH]

It's hard to see, but there are two spaces before each of the lines starting with the line "NEW_COLUMN_1"

 

[Marco Kalter]

We'll check it out and will try to enhance this.

 

[MjH]

Thanks, Marco