Oracle Error PLS-00705: exception ‘string’ used in expression requiring return type

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.