Using SQL and Host-language Statements

Go Up to Guidelines for Error Handling

All SQL statements and InterBase functions can be used in error-handling routines, except for CONNECT.

Any host-language statements and functions can appear in an error-handling routine without restriction.

Important: Use WHENEVER SQLERROR CONTINUE at the start of error-handling routines to disable error-handling temporarily. Otherwise, there is a possibility of an infinite loop; should another error occur in the handler itself, the routine will call itself again.