ERROR | exception string used in expression requiring return type |
CAUSE | An exception was referred to in an expression. Exceptions have names but not values and therefore cannot contribute values to an expression. For example, the following RETURN statement is illegal: FUNCTION credit_limit (cust_no INTEGER) RETURN NUMBER IS limit NUMBER; over_limit EXCEPTION; ... BEGIN ... RETURN over_limit; -- illegal END; |
ACTION | Check the spelling of the identifiers in the expression, then rewrite the expression so that it does not refer to an exception. |