RE: Ctrl C in SQLPlus exits Windows
- From: "Jeffrey Beckstrom" <jbeckstrom@xxxxxxxxx>
- To: "oracle-l-freelist" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Mar 2019 08:04:01 -0400
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@xxxxxxxx> 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@xxxxxxxxxxxxx
[
mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Sunday, March 10, 2019 4:29 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
