PLS-00503: RETURN lamp;lt;lamp;nbsp;valuelamp;gt; statement required for this return from function

PLS-00503: RETURN lamp;lt;lamp;nbsp;valuelamp;gt; 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.

No comments:

Post a Comment