SQL*Plus Overwrites Unix Command Signal Int ( KiLl -2 ) Trap in Calling Script
(Doc ID 341412.1)
Last updated on FEBRUARY 03, 2022
Applies to:
SQL*Plus - Version 9.2.0.5 and laterInformation in this document applies to any platform.
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 |