My Oracle Support Banner

SQL*Plus Overwrites Unix Command Signal Int ( KiLl -2 ) Trap in Calling Script (Doc ID 341412.1)

Last updated on FEBRUARY 25, 2019

Applies to:

SQL*Plus - Version 9.2.0.5 and later
Information in this document applies to any platform.
*** Checked for relevance on 25-Feb-2019 ****

Symptoms

Sqlplus is ignoring the trap to stop CTRL-C from ending sqlplus.

There are 2 scripts:
One that starts sqlplus:
myPlusTest:
-----------
sqlplus -s  <USER>/<PASSWORD> <
exec dbms_lock.sleep(12345); 


One that calls this script and has delays:
runPlusTest:
------------

trap "break" INT
myPlusTest &
var=$!
while :
do 
        clear 
        ptree $var 
        sleep 3
done

When runPlusTest is called, a CTRL-C kills the sqlplus started within myPlusTest

However, if myTest was using a OS command, that would ignore the Ctrl-C and continue processing.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.