Code Inspection: Missing return statement

Reports functions that have no RETURN statements.

Example (Oracle):

CREATE FUNCTION foo RETURN int AS
BEGIN
END;

The foo function must return the integer value but the function body returns nothing. To fix the error, add a RETURN statement (for example, return 1;).

CREATE FUNCTION foo RETURN int AS
BEGIN
 RETURN 1;
END;