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-00385: cannot enable Very Large Memory with new buffer cache parameters
ORA-06900: CMX: cannot read tns directory
EXP-00060: an object type had multiple TYPE BODYs
ORA-13018: bad distance type
ORA-00231: snapshot controlfile has not been named
ORA-01502: index 'string.string' or partition of such index is in unusable state
ORA-16027: parameter string is missing a destination option
ORA-09980: skxfqdrcv: Error Receiving a message from another endpoint
ORA-38720: Missing log file number.
ORA-19321: Could not open HTTP connection to host (string): port (string)
ORA-32130: invalid offset/index refrenced in Bytes
RMAN-06470: DEVICE TYPE is supported only when automatic channels are used