SQL Statements › SQL Statements › CREATE PROCEDURE Statement › RAISE ERROR Syntax

RAISE ERROR Syntax

►►─ RAISE ERROR ─ (signal-value,error-message-text) ──────────────────────────►◄

Expansion of signal-value

├──┬─ condition-name ─┬────────────────────────────────────────────────────────┤
   └─ sqlstate-value ─┘

The RAISE ERROR statement functions identically to the following SIGNAL statement syntax:

►►─ SIGNAL ─┤ signal-value ├─ SET MESSAGE_TEXT = ─ error-message-text ────────►◄

Expansion of signal-value

├──┬─ condition-name ─┬────────────────────────────────────────────────────────┤
   └─ sqlstate-value ─┘

For more information on the SIGNAL statement, see SIGNAL Syntax.