SQL Plus silent mode problem

From: <carvedude_at_my-deja.com>
Date: Thu, 07 Dec 2000 12:16:38 GMT
Message-ID: <90nv31$725$1@nnrp1.deja.com>

I'm using SQLPlus in silent mode to run a batch script like (sqlplus -s scott/tiger_at_TESTDB @myscript.sql).

This works perfect when the database is available. If the database is not available the SQLPlus tries to connect to the database and gets into the SQLPlus prompt for logon information. Does anybody know how to get straight to the exit after the database is not available? Otherwise my script hangs for years!!!

Thanks in advance
Rico Brun

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 07 2000 - 06:16:38 CST