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-01129: user's default or temporary tablespace does not exist
NZE-28792: PL/SQL operation failure
NZE-29222: Distinguished name does not match.
PLW-05000: mismatch in NOCOPY qualification between specification and body
QSM-01110: a lossy join in MV, string, between tables, string, not found in query
ORA-07584: spdcr: invalid value for ORA_sid_(proc_)PQL$_item
ORA-24351: invalid date passed into OCI call
ORA-00224: controlfile resize attempted with illegal record type (string)
TNS-12699: Native service internal error
ORA-06707: TLI Driver: connection failed
ORA-25151: Rollback Segment cannot be created in this tablespace
DRG-13311: USER_LEXER stored procedure name contains a semicolon