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

ORA-12490: DBHIGH cannot be lowered

1 Answers  


ORA-22061: invalid format text [string]

1 Answers  


ORA-13523: unable to allocate required space for return type

1 Answers  


ORA-39958: invalid warning category qualifier

1 Answers  


ORA-01352: tablespace given for Logminer spill does not exist

1 Answers  


ORA-03113: end-of-file on communication channel

1 Answers  


ORA-39308: application/database upgrade internal error: "string"

1 Answers  


NID-00300: Connected to database string (DBID=number)

1 Answers  


ORA-25198: only range, list, and hash partitioning are supported for index-organized table

1 Answers  


ORA-31444: parameter error while acquiring lock on string

1 Answers  


ORA-39957: invalid warning category

1 Answers  


ORA-01023: Cursor context not found (Invalid cursor number)

1 Answers  


Categories