Re: Ctrl C in SQLPlus exits Windows

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
> <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> 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
>
>

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