RE: Ctrl C in SQLPlus exits Windows

Demo/GIFs for this in SQLcl here

https://www.thatjeffsmith.com/archive/2019/03/cancelling-in-oracle-sqlcl/

note that hitting ctrl+c won’t always give you immediate relief with the jdbc driver on Oracle, it’s up to the db when it wants to really ‘let go’ – you might find better responsiveness with a THICK/OCI connection.

Jeff

From: Mladen Gogala <gogala.mladen_at_gmail.com> 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:

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__grokbase.com_t_freelists.org_oracle-2Dl_095myarkwd_11g-2Dsqlplus-2Don-2Dwindows-2Dand-2Dctrl-2Dc&d=DwMDaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=1jvY6LMGdWRVzdRA6FObHu2Pcp9UR3j3seYUP9mHrP4&s=AMWSxS02FFmpM3LJ0DUFd99IBz2lgBGCIuj238HJvi8&e="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

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