Re: 11g sqlplus on Windows and ctrl-C

  • From: Adric Norris <spikey.mcmarbles@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 May 2009 07:30:22 -0500

On Thu, May 21, 2009 at 1:14 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:

> When I read your mail I had a feeling that you are not entirely correct.
> I checked with sqlplus, 10.2, and found out that the first CTRL+C terminate
> the current command and remain in sqlplus.
> It is the SECOND CTRL+C that aborts and return to the command prompt.
>

That's the theory, but the reality is a bit more complex.  If sqlplus is
sitting at an ACCEPT prompt, for example, then ctrl-C will kill it rather
than simply terminating the script (as it does on all other platforms I'm
familiar with).  There are plenty of other scenarios as well.

Since Windows maps ctrl-C to Copy for non-console programs, it's
unfortunately quite easy to input it by mistake.  Fortunately, that's fairly
benign in any other environment (Linux/Unix, or sqlplusw.exe on Windows).

-- 
"I'm too sexy for my code." - Awk Sed Fred.

Other related posts: