Use this statement to signal an exception condition.
SIGNAL exception-name
SIGNAL allows you to raise an exception. For a description of how exceptions are handled, see Using exception handlers in procedures and triggers.
Use exception-name to specify the name of an exception declared using a DECLARE statement at the beginning of the current compound statement. The exception must correspond to a system-defined SQLSTATE or a user-defined SQLSTATE. User-defined SQLSTATE values must be in the range 99000 to 99999.
None.
None.
SQL/2003 Persistent Stored Module feature.
The following compound statement declares and signals a user-defined exception. If you execute this example from Interactive SQL, the message My exception signaled appears on the Messages tab in the Results area.
BEGIN DECLARE myexception EXCEPTION FOR SQLSTATE '99001'; SIGNAL myexception; EXCEPTION WHEN myexception THEN MESSAGE 'My exception signaled' TO CLIENT; END |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |