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

"Andrew King" <kingster_1969_at_hotmail.com> wrote in message news:ufv4gi7p1v2ja9_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
>
>

What does the explanation of whenever sqlerror in your sql*plus documentation say?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address