Handle db connection errors batch scripts

Question

I have the following code:

sqlplus web/%password%@%SID% @ web.sql > weblog.log < NUL

if %ERRORLEVEL% > 0 GOTO SQLERROR

:SQLERROR

echo wrong credentials

The problem is, when I give wrong SID or password it pauses for some seconds and does not go to the error. Any help? Thanks.

It only pauses for a few seconds, it doesn't hang indefinitely - or at least until you hit return a few times, or interrupt it? Possible duplicate - does adding the -l flag make it behave how you want it to?. — Alex Poole
– Alex Poole, Commented Aug 2, 2017 at 18:31
It pauses for some secs, it does not respond to whatever i type except ctrl+c, the error is logged in weblog though. — user4860402
– user4860402, Commented Aug 2, 2017 at 18:33

Magoo · Accepted Answer · 2017-08-03 01:06:21Z

0

if %ERRORLEVEL% gtr 0 GOTO SQLERROR

> is a redirector. You must use one of ==, gtr, geq, equ, neq, 'lss, 'leqin anif` statement.

answered Aug 3, 2017 at 1:06

Magoo

80.8k8 gold badges68 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you. The delay was caused because of the 3 attempts to connect to the database.