As for interrupting SQL, there is the following command which works in
some versions newer than 9i:
ALTER SYSTEM CANCEL SQL 'SID, SERIAL[, @INST_ID][, SQL_ID]';
If that doesn't happen to work in your database, you can always try with
kill -SIGURG <pid executing SQL>. That is actually what the above
command does.
Regards
On 3/11/19 10:26 AM, Tim Hall wrote:
I would expect SQLcl to work fine on Ubuntu. Just unzip and go. Never
tried it though... :)
https://oracle-base.com/articles/misc/sqlcl-installation
SQLcl on Windows will also close as a result of a CTRL+C. At least it
does for me.
Cheers
Tim...
On Mon, Mar 11, 2019 at 1:59 PM Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
I am using Ubuntu 18.04 so the only thing I can use is an instant client.
Regards
On 3/11/19 9:40 AM, Andy Sayer wrote:
In 18c I’ve found that the behaviour is now:
Works half the time.
The rest of the time it doesn’t do anything until when the statement would have
started returning anything, it stops and returns control then.
Try upgrading your Oracle Client version
Thanks,
Andy
On Mon, 11 Mar 2019 at 12:04, Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx> wrote:
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
Open yourself another window, and since you must be DBA on your home play"Mark W. Farnham" <mwf@xxxxxxxx> 3/10/19 11:35 AM >>>
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 Gogala
Database Consultant
Tel: (347) 321-1217
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
