RAISE

This statement raises an exception.

RAISE is only valid within a scripting block.

See also EXCEPTION.

Syntax

RAISE name;

Arguments

name: The name of the exception.

Usage Notes

Within an exception handler, you can raise the same exception again without specifying the name.

Example 1

CREATE PROCEDURE mkw_doku.exception_proc
RETURNS STRING
AS
    DECLARE
        MY_EXCEPT EXCEPTION;
    BEGIN
        RAISE MY_EXCEPT;
    END;

CALL mkw_doku.exception_proc;

[object Object]
 at mkw_doku.exception_proc (7:9)
 at mkw_doku.test_abfragen (11:1)

Example 2

CREATE PROCEDURE mkw_doku.exception_proc2
RETURNS STRING
AS
    DECLARE
        MY_EXCEPT EXCEPTION (734001, 'On your whish: Raised MY_EXCEPT.');
    BEGIN
        RAISE MY_EXCEPT;
    END;

CALL mkw_doku.exception_proc2;

On your whish: Raised MY_EXCEPT.
 at mkw_doku.exception_proc2 (7:9)
 at mkw_doku.test_abfragen (12:1)