Re: How to disable < control + C > key in SQL*PLUS

From: <yltong_at_oliv1.oli.hk>
Date: Tue, 19 May 1998 04:30:56 GMT
Message-ID: <6jr1j7$7c6@du04.oli.hk>

I have tried your suggestion but failed. In my case, I write SQL script to ask user to input some values before execution. I want to prevent user pressing < CRTL+C> to exit to SQL prompt. Here is my script:

SET ESCAPE OFF
spool %windir%\temp\test.log
set verify on
accept PUR_DATE prompt 'Purge History Log before (DD-MMM-YYYY) : ' set termout off
lock table sahistlog in exclusive mode; delete from sahistlog

        where print_fg = '1' and 
              date_log <= '&PUR_DATE';

commit;
spool off;
exit;

Thanks again.

In article <356142f6.2383607_at_news2.mm.com>, johng_at_nospam.mm.com wrote:
>Try SET ESCAPE = OFF
>as the first line of your script.
>
>
>
>yltong_at_oliv1.oli.hk wrote:
>
>> As the subject mentioned, I won't user can the stop my sql script to exit to
>>SQL prompt during running.
>>
>
Received on Mon May 18 1998 - 23:30:56 CDT