Oracle Message PLS-00705 - exception string used in expression requiring return type

ERRORexception string used in expression requiring return type
CAUSEAn 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;
ACTIONCheck the spelling of the identifiers in the expression, then rewrite the expression so that it does not refer to an exception.