Control + C doesn't work properly in SQLPlus

[Marcel Paul]

Hello,

I would like to ask you for help with the issue I encounter in
SQLPlus. When I run a command and want to interrupt it with Control +
C (^C), i'm not able to do so as the command is running further.
Moreover if I press ^C on empty command line and the want to run any
command I have no output as well as I'm not able to quit SQLPlus
properly. I believe it's some configuration issue but can't find it. I
already tried to play with stty terminal command as well as with $TERM
env. variable but was not able to fix the issue.
When I connect to server where the database is running locally and run
SQLPlus from there it works fine.
I would be thankful for any hint.

Best regards,
Marcel

[George Nachman]

If you run:

stty -a

does it say:

intr = ^C

If not, run this command before starting SQLPlus:

stty intr ^C

and see if that helps.

[Marcel Paul]

Hello, thanks for the quick answer..

Yeah, intr is set to ^C, that was first thing I checked. Even in
terminal in SQLPlus when I press it I can see it on the screen as the
last characters. After these characters I can't write anything, no
output is sent to screen, everything just hangs.

Best regards,
Marcel

[George Nachman]

It sounds like SQLPlus is probably catching the signal. You can try
^\, which sends the QUIT signal, and is not usually caught.

[Marcel Paul]

I believe it's the way how Oracle handle ^C command sent via network
as local connection works fine.
I checked the ^\ command before and it worked but it's a kill of an
entire session when I got completely disconnected.
Thanks for your help.

Marcel

[George Nachman]

Sorry, I'm not sure what's going on. Usually, configuring stty to send
intr for ^C does the trick. There may be a bug in the SQLPlus client.

[Marcel Paul]

i think problem will be somewhere else.. thanks for your support.

best regards,
marcel