PLS-00503
RETURN value statement required for this return from function
Cause
In a function body, a RETURN statement was used that contains no expression. In procedures, a RETURN statement contains no expression because the statement simply returns control to the caller. However, in functions, a RETURN statement must contain an expression because its value is assigned to the function identifier.
Action
Add an expression to the RETURN statement.