SQL*Plus Overwrites Unix Command Signal Int ( KiLl -2 ) Trap in Calling Script
Last updated on AUGUST 14, 2017
Applies to:SQL*Plus - Version: 22.214.171.124
This problem can occur on any platform.
Sqlplus is ignoring the trap to stop CTRL-C from ending sqlplus.
There are 2 scripts:
One that starts sqlplus:
sqlplus -s user/password <
One that calls this script and has delays:
trap "break" INT
When runPlusTest is called, a CTRL-C kills the sqlplus started withing myPlusTest
However, if myTest was using a OS command, that would ignore the Ctrl-C and continue processing.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms