Re: Ctrl C in SQLPlus exits Windows

As for interrupting SQL, there is the following command which works in some versions newer than 9i:

ALTER SYSTEM CANCEL SQL 'SID, SERIAL[, _at_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_at_gmail.com> 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_at_gcrta.org> 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
>>>
>>>>>> "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 Gogala
>>>
>>> Database Consultant
>>>
>>> Tel: (347) 321-1217
>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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