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 |
ORA-01561: failed to remove all objects in the tablespace specified
PLS-01414: Use of qualified expression here
ORA-27213: failed to unload Media Management Library
ORA-00206: error in writing (block string, # blocks string) of controlfile
ORA-32615: incorrect use of MODEL IS ANY predicate
ORA-02147: conflicting SHARED/EXCLUSIVE options
DRG-50608: unexpected end of data
ORA-32106: array fetch not allowed without setBuffer on all columns
RMAN-11000: message number number not found in recovery manager message file
ORA-14306: List value 'string' specified twice in partitions 'string', 'string'
PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP
RMAN-08537: channel string: skipped, autobackup already found