Re: Call SQL script from Windows .bat file with error checking **NEWBIE**

Piece of cake.

Make sure your SQL script contains this line at the beginning:

WHENEVER SQLERROR EXIT SQL.SQLCODE; Make sure it has a normal EXIT; at the end

In your batch script, check for the error this way:

IF ERRORLEVEL=(sql error code) (do something)

JP

"Andrew King" <kingster_1969_at_hotmail.com> wrote in message news:<ufv66g7e7ta8c3_at_corp.supernews.com>...
> I am currently trying to call a SQL*Plus script from a Windows batch file.
> I have figured it all out, except for one little piece - I need an error
> code returned to the %errorlevel% environment variable if there is a problem
> in the execution of the script/stored proc.
>
> This is what I have so far in my batch file:
>
> set ORACLE_SID=edwm
> set ORACLE_HOME=d:\oracle\ora81ee
> D:
> cd D:\ora\edwm\whs\sql
> d:\oracle\ora81ee\bin\sqlplus username/password @whsverify.sql
>
> I have seen things in some scripts/stored procs that I have looked at like
> "whenever sqlerror exit SQL.SQLCODE". Will this do what I am looking for?
>
> Thanks,
>
> Andy
Received on Fri Jun 07 2002 - 09:16:00 CDT