DB2 Version 10.1 for Linux, UNIX, and Windows

RAISE statement (PL/SQL)

The RAISE statement raises a previously-defined exception.

Syntax


>>-RAISE--exception--------------------------------------------><

Description

exception: Specifies a previously-defined exception.

Example

The following example shows a procedure that raises an exception of oddno or evenno based on the value provided as argument in the invocation::

CREATE OR REPLACE PROCEDURE raise_demo (inval NUMBER) IS
  evenno EXCEPTION;
  oddno  EXCEPTION;
BEGIN
  IF MOD(inval, 2) = 1 THEN
    RAISE oddno;
  ELSE
    RAISE evenno;
  END IF;
EXCEPTION
  WHEN evenno THEN
    dbms_output.put_line(TO_CHAR(inval) || ' is even');
  WHEN oddno THEN
    dbms_output.put_line(TO_CHAR(inval) || ' is odd');
END raise_demo;
/

SET SERVEROUTPUT ON
/

CALL raise_demo (11)
/

The output of the CALL statement would be:

CALL raise_demo (11)

 Return Status = 0

11 is odd