HomeOracleOracle Error PLW-05005: subprogram string returns without value at line string

Oracle Error PLW-05005: subprogram string returns without value at line string

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...