Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus question
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