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



PLS-00705: exception 'string' used in expression requiring return type..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2I-00126: You must specify an INTYPE file with SCHEMA_NAMES=FROM_INTYPE

1 Answers  


EXP-00039: export file string must be on a disk

1 Answers  


PLS-00104: empty argument list in call of procedure 'string' must be omitted

1 Answers  


ORA-31424: change table has active subscriptions

1 Answers  


ORA-12039: unable to use local rollback segment "string"

1 Answers  






ORA-12423: invalid position specified

1 Answers  


ORA-25190: an index-organized table maintenance operation may not be combined with other operations

1 Answers  


ORA-23503: error occurred during IAS instantiation

1 Answers  


ORA-13207: incorrect use of the [string] operator

1 Answers  


ORA-26566: Couldn't open connect to string

1 Answers  


TNS-12529: TNS:connect request rejected based on current filtering rules

1 Answers  


TNS-00082: NOTE: the user MUST specify a trace level

1 Answers  


Categories