PLS Database Error Messages

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

oracle

PLS-00705: 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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/