Originally posted by Mr.Hanky

sqlplus Mr.Hanky/[email protected]
@C:\test_sql.sql

This does not execute the second line, if I put it on one line it works fine.

MH
If you type @c:\test_sql.sql from a c:> prompt would it run? Of course not. By the time the Command Intrepreter gets to @c:\test_sql.sql the sqlplus command is already done.

In unix, the command would be something like:
Code:
sqlplus system/[email protected] << EOF
@c:\test_sql.sql
EOF
This would tell the command intrepreter to continue reading the following stream as input until you reach the string "EOF". I don't waste my time with WindoZ, so I can't tell you if DOS (which WindoZ is really based on) has a way to do redirection.