How to close Toad from the command line such as running a procedure, then close it when it is done?
There is no command to close Toad fromthe command prompt or acommand(cmd)file.
A possible alternative would be to use Quest Script Runner, QSR.exe. It is located in the same directory as Toad and has a parameter e which will exit after the script is ran.
Running Quest ScriptRunner from the Command Line
Launching Quest ScriptRunner only
Without a connection
You can launch Quest ScriptRunner from the command line by entering:
QSR
at the command prompt. Entered as above, with no command line arguments and no forward slash, Quest ScriptRunner will launch and prompt for a connection.
Specify a connection
You can specify a connection on the command line in the following formats.
This example connects directly to the database you have specified, using the username and password you specified.
QSR<username></username>/<password></password>@<databasename></databasename>
QSR demo/demo@mydatabase
In this example, Quest ScriptRunner will attempt to connect using a blank/default database name.
QSR demo/demo
In this example, Quest ScriptRunner will attempt to connect using an OPS$ login.
QSR /
Launching Quest ScriptRunner and loading a file
You can also specify a file to load when Quest ScriptRunner is launched.
QSR demo/demo@mydatabase c:\temp\mysql.sql
Quest ScriptRunner will attempt to connect using the specified connection and will load the file into the editor panel. If a filename or path contains spaces, the entire path must be enclosed in double quotes
as follows:
QSR demo/demo@mydatabase c:\temp\my sqlfiles\mysql.sql
Additional Command Line Options supported
-?
qsr.exe jsmith/jsmith@mydatabase -?
-e (or /e)
exit after execute script (over rides call other exit flags)
-h (or /h)
OracleHomePath: this flag is followed by the path to the Oracle home you want to use
-i (or /i)
runs QSR iconic (minimized)
-s (or /s)
QSR will stay open even if the exit after execute INI setting is set
-HELP
qsr.exe jsmith/jsmith@mydatabase -help
Passing in the name of a script to load but not to run, e.g.
qsr.exe jsmith/jsmith@mydatabase c:\parentscript.sqll
Output redirection (saves output to destination file after running the script designated in the command line), e.g.
qsr.exe jsmith/jsmith@mydatabase @c:\quest scriptrunner\sga.sql
>c:\quest scriptrunner\sgaoutput.txt
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center