Using Exception Handlers in Procedures

Certain types of errors can be intercepted and handled within a procedure, rather than passing the error back to the calling environment. This is done through the use of an exception handler.

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Stored Procedures and Triggers > Using procedures, triggers, and batches > Errors and warnings in procedures and triggers > Using exception handlers in procedures and triggers.

Note:

Sybase IQ does not support triggers. Information on triggers in the SQL Anywhere documentation can be ignored.