SQL Statements › CREATE PROCEDURE › CREATE PROCEDURE Syntax and Description › Example

Example

A SIGNAL statement example follows. Another SIGNAL statement example can be found in the section labeled SIGNAL orderApproved in Sample Procedure 2. In the example that follows, logic that is not shown (for space considerations) is indicated by three vertically arranged periods.

 .
 .
 .
 IF creditReqAmt > creditAvailable
  SIGNAL SQLSTATE '2FS04'
   SET MESSAGE_TEXT = 'CUSTOMER HAS INSUFFICIENT CREDIT LIMIT TO COMPLETE PURCHASE';
 END IF;
 .
 .
 .