![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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
• An ON or UNTIL statement can detect an exception raised by the SIGNAL statement, and subsequently issue actions.
• 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.
2.
• 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 |