Re: sqlplus question

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 13 Mar 2003 06:45:01 +0100
Message-ID: <nk607vcttcbpo6soob8aj4popbai11d8gm@4ax.com>

On Thu, 13 Mar 2003 00:09:06 -0500, "Anurag Varma" <avdbi_at_hotmail.com> wrote:

>.. now in the above example, it would be a bad thing if it fails the second connection and drops
>object within the first user.
>
>.. that is just an example though
>
>Anurag

So just add
whenever sqlerror exit failure
as the first line of your script
and the table won't be dropped when the connect fails.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 12 2003 - 23:45:01 CST