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

Example

A RAISE ERROR statement example follows. In the example that follows, logic that is not shown (for space considerations) is indicated by three vertically arranged periods.

 .
 .
 .
 IF creditReqAmt > creditAvailable
  RAISE ERROR ('2FS04', 'CUSTOMER HAS INSUFFICIENT CREDIT LIMIT TO COMPLETE PURCHASE');
 END IF;
 .
 .
 .