Re: SQLPlus batch runs with auto-exit

From: Alex P. Zotov <alex_at_soft-review.kiev.ua>
Date: Tue, 25 Jan 2000 15:08:09 +0200
Message-ID: <AAx0QZuS803@soft-review.kiev.ua>

Eric Yu <ericyu_at_centerprise.com.NO_SPAM> wrote in message news:KQ5j4.2420$kp5.3395_at_client...
> How can you run a sql script in batch (DOS/NT) w/SQLPLUS, so that SQLPLUS
> auto-exits after running the script commands (w/o having to put an
explicit
> EXIT command into the script)? [Oracle 8.x versions, if that matters...]
>
> Thx,
> Eric

You'd create to files: executable batch fiel and file with sql commands. Contents of batch file:
%ora_home%\bin\Sqlplusw.exe usr_name/password_at_connect_string @sql_file.sql

Contentsof sql file:
command1;
...
exit;

The %ora_home% is patch to your oracle location. --
Alex P. Zotov Received on Tue Jan 25 2000 - 07:08:09 CST