Errors and Warnings in Procedures

After an application program executes a SQL statement, it can examine a return code (or status code) for errors.

The return code indicates whether the statement executed successfully or failed and gives the reason for the failure.

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.

• Default Error Handling in Procedures
  Sybase IQ handles errors that occur during a procedure execution.
• Error Handling With ON EXCEPTION RESUME
  The ON EXCEPTION RESUME clause is included in the CREATE PROCEDURE statement.
• Default Handling of Errors and Warnings in Procedures
  Errors and warnings are handled differently in procedures.
• 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.
• Nested Compound Statements and Exception Handlers
  Nested compound statements can be use to give users more control over which statements execute following an error and which do not.