RETURN statement v16

The RETURN statement terminates the current function, procedure, or anonymous block and returns control to the caller.

Syntax

The RETURN statement has two forms. The first form of the RETURN statement terminates a procedure or function that returns void. The syntax of this form is:

RETURN;

The second form of RETURN returns a value to the caller. The syntax of this form is:

RETURN <expression>;

expression must evaluate to the same data type as the return type of the function.

Example

This example uses the RETURN statement and returns a value to the caller:

CREATE OR REPLACE FUNCTION emp_comp (
    p_sal           NUMBER,
    p_comm          NUMBER
) RETURN NUMBER
IS
BEGIN
    RETURN (p_sal + NVL(p_comm, 0)) * 24;
END emp_comp;

• On this page
• Syntax
• Example