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 |
RMAN-06607: RMAN configuration parameters are:
RMAN-06026: some targets not found - aborting restore
TNS-12631: Username retrieval failed
ORA-31511: name exceeds maximum length of 30 characters
ORA-30460: 'string.string' cannot be refreshed because it is marked UNUSABLE
ORA-12523: TNS:listener could not find instance appropriate for the client connection
TNS-02524: Authentication: privilege check failed
QSM-02162: the detail table does not have a materialized view log
TNS-02401: gbname string too long, allowed number characters
ORA-12025: materialized view log on "string"."string" already has primary keys
ORA-32106: array fetch not allowed without setBuffer on all columns
ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE