Re: Ctrl C in SQLPlus exits Windows

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
> <mailto: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
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
> Cleveland, Ohio 44113
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
>
> >>> "Mark W. Farnham" <mwf_at_rsiz.com <mailto: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>
> [mailto: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 <mailto: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


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