RE: Ctrl C in SQLPlus exits Windows

For us, about half the time the sql only is killed and the other half sqlplus is killed.

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

>>> "Mark W. Farnham" <mwf_at_rsiz.com> 3/10/19 11:35 AM >>>
>Open yourself another window, and since you must be DBA on your home
play version, look up the server process you want to kill and kill it. The prompt should return to your sqlplus session awaiting you to log back on. (If memory serves. It’s been a long time.)  

I am not aware of a workaround for ctrl-c or inserting rubout in data from the keyboard to avoid crashing that window of sqlplus on the system you’re using.  

Probably there are some virtual wrapper VM software varieties on which you can run a guest of windows that will behave differently.  

mwf  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Sunday, March 10, 2019 4:29 AM
To: oracle-l_at_freelists.org
Subject: Re: Ctrl C in SQLPlus exits Windows  

Hi Ram!
What would you like to interrupt? Interrupt signal is always dispatched to the invoking process and it kills it. The sqlplus is not bad, it was just drawn that way, to quote Jessica Rabbit. I would try with SQLcl, Java plug in replacement for SQL*Plus. As I use Linux, I am not sure that this will work, but it's worth trying. Jeff Smith can probably tell you more.
Regards
On 3/10/19 3:58 AM, Ram K wrote:

Installed Oracle in my home Windows PC and playing around with it. But pressing Ctrl-C always exits SQL Plus, when I run queries. grr... Tried searching online and found this:  

https://grokbase.com/t/freelists.org/oracle-l/095myarkwd/11g-sqlplus-on-windows-and-ctrl-c  

Is there a solution for Ctrl C only to interrupt and not to exit SQL Plus in windows.  

-- 
Thanks,
Ram.
-- Mladen GogalaDatabase ConsultantTel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l