Oracle Error Message
PLS-00705: exception ‘string’ used in expression requiring return type
Reason for the Error
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;
Solution
Check the spelling of the identifiers in the expression, then rewrite the expression so that it does not refer to an exception.