Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 7 The Exception Statements : SIGNAL Statement

SIGNAL Statement
The SIGNAL statement raises the exception specified within the statement. You use the SIGNAL statement to raise user-defined exceptions within your rules.
Usage of SIGNAL
A SIGNAL statement contains:
1.
2.
3.
Usage Notes
When using the ON or UNTIL statements, you must provide the exception name given in the SIGNAL statement; you cannot use an indirect reference in the SIGNAL statement. To use an indirect reference, use the $SIGNAL tool.
If you issue a SIGNAL statement from within a trigger or validation rule, the trigger or validation rule must explicitly handle the exception within its calling hierarchy. If it is not explicitly handled, the transaction that caused the trigger or validation terminates.
Examples
1.
2.
ON GETFAIL MANAGER :
   SIGNAL UNKNOWN_NAME;
About the Examples
In example 2, the GETFAIL exception signals the user-defined exception UNKNOWN_NAME if the GET fails on the MANAGER table.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved