Oracle Error Message
PLW-05005: subprogram string returns without value at line string
Reason for the Error
A function terminated without a return value. RETURN statements with values are required for all PL/SQL functions.
Solution
Inspect function source code to ensure that every RETURN statement returns a value and that a function does not terminate by executing its END statement. Notice that this message may appear at the call site for a function if the function call was inlined and if the called function did not terminate properly.