Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus question

Re: sqlplus question

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 13 Mar 2003 01:51:55 -0500
Message-ID: <v70akg78176497@corp.supernews.com>


ok .. so my example crashed and burned <g> Anurag

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:nk607vcttcbpo6soob8aj4popbai11d8gm_at_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 Thu Mar 13 2003 - 00:51:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US