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

Sybrand Bakker wrote:

> "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

Asking someone to look at the documentation ... have you no shame? <g>

Daniel Morgan Received on Thu Jun 06 2002 - 16:18:48 CDT