Oracle Error ORA-06503: PL/SQL: Function returned without value

Oracle Error Message

ORA-06503: PL/SQL: Function returned without value

Reason for the Error

A call to PL/SQL function completed, but no RETURN statement was executed.

Solution

Rewrite PL/SQL function, making sure that it always returns a value of a proper type.