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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to disable < control + C > key in SQL*PLUS

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

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: Tue, 19 May 1998 22:44:54 -0500
Message-ID: <356251B5.6FDED0B0@deere.com>


This works on unix:

host stty intr ^V
host stty eof ^C
Better yet, in the unix shell script!

do your sql script

host stty eof ^D
host stty intr ^C
Better yet, in the unix shell script!

If the user enters a ^C, he actually gets the end of file (usually ^D)

Be sure to put them back

yltong_at_oliv1.oli.hk wrote:

> 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 Tue May 19 1998 - 22:44:54 CDT

Original text of this message

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