Using SQL Plus, you can run a script with the "@" operator from the command line, as in:
c:\>sqlplus username/password@databasename @"c:\my_script.sql"
But is it possible to just run a single command with a similar syntax, without a whole separate script file? As in:
c:\>sqlplus username/password@databasename @execute some_procedure
I am interested in this because I want to write a batch file that simply executes a command, without generating a bunch of two-line ".sql" files.
I'm able to run an SQL query by piping it to SQL*Plus:
@echo select count(*) from table; | sqlplus username/password@database
Give
@echo execute some_procedure | sqlplus username/password@databasename
a try.
Have you tried something like this?
sqlplus username/password@database < "EXECUTE some_proc /"
Seems like in UNIX you can do:
sqlplus username/password@database <<EOF
EXECUTE some_proc;
EXIT;
EOF
But I'm not sure what the windows equivalent of that would be.
sqlplus user/password@sid < sqlfile.sql
This will also work from the DOS command line. In this case the file sqlfile.sql contains the SQL you wish to execute.