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

Code Example 2

 .
 .
 .
 DECLARE sqlState, sqlStateLocal CHAR(5) DEFAULT '00000';
 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND
    GET STACKED DIAGNOSTICS sqlCodeLocal =
 RETURNED_SQLSTATE;
 .
 .
 .
 INSERT INTO orderTable VALUES (customerId, orderId, orderStatus, orderComments);
 IF sqlStateLocal <-> '00000' THEN
    LEAVE thisCompoundStatement;
 END IF;
 .
 .
 .