Re: SQL*PLUS interrupt question

In article <CJ42wI.1wF_at_ncrcae.ColumbiaSC.NCR.COM>, sanju_at_churchill.ColumbiaSC.NCR.COM (Sanjeev.Agrawal) writes:
>
> Wish you all a very happy and eventful new year.
>
> Now the problem:
>
> I am running an sqlplus script from command line in silence mode.
> If user interrupts the operatin the control remains in sqlplus
> and it does not come back to operating system.
>
> Any pointers will be highly appreciated.
>
> Thanks in advance,
>
> Sanjeev
> --
> *-------------------------------------------------------------------------*
> | Sanjeev Kumar Agrawal Phone: (803) 939-6835(W) / 791-9048 (H) |
> | Think there is a Better Way to Do It ! |
> *-------------------------------------------------------------------------*

The first interrupt is trapped by SQL*Plus and breaks it's current operation. A further interrupt (or press EXIT) and you break out of the SQL*Plus executable.

Have a look at the WHENEVER OSERROR|SQLERROR command for trapping and exiting cleanly (Oracle7).

-- 
Bruce...        pihlab_at_cbr.hhcs.gov.au

"If you swallow a live frog first thing in the morning ...
 Nothing worse will happen to either of you for the rest of the day."

*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of                                      * 
*          Health, Housing, Local Government & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************