Exception, signal, and interrupt handler considerations
An exception, signal,
or interrupt handler is a routine that gains control when an exception,
signal, or interrupt occurs. The type of handler used is determined
by your operating environment.
- Windows operating systems
- Pressing
Ctrl-CorCtrl-Breakgenerates an interrupt. - UNIX operating systems
- Usually, pressing
Ctrl-Cgenerates the SIGINT interrupt signal. Note that keyboards can easily be redefined so that SIGINT can be generated by a different key sequence on your machine.
Do
not put SQL statements in exception, signal, and interrupt handlers.
With these kinds of error conditions, you normally want to do a ROLLBACK
to avoid the risk of inconsistent data. Before issuing a ROLLBACK,
call the INTERRUPT API (sqleintr/sqlgintr).
This API interrupts the current SQL query (if the application is executing
one) and lets the ROLLBACK begin immediately.
Refer to your platform documentation for specific details on the various handler considerations.