Explanation
The author of a procedure can trigger a condition-handler to handle a condition that is not an error and signal an error while omitting an error message. In the message text, the variable user-cond-name is the name you give the condition you are signalling. For example, the statement SIGNAL ORDER_APPROVED could be used to trigger a handler that inserts a GET THIS ORDER READY row into a list of things to do for a warehouse worker. The purpose of this message is to be used in such a case.
The SQLSTATE that equates to this SQL return code is 2FS03.
User Response
None. This message is for information only. The successful execution of the condition-handler clears the error codes and message, which are there to serve only as defaults.
|
Copyright © 2014 CA.
All rights reserved.
|
|