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-19693: backup piece string already included
ORA-38757: Database must be mounted EXCLUSIVE and not open to FLASHBACK.
QSM-01081: no primary key or row id found for table, string, in MV, string
ORA-28021: cannot grant global roles
LSX-00154: attribute "use" must have its value set to "optional"
ORA-24034: application string is already a subscriber for queue string
ORA-25532: MTTR specified is too large: string
QSM-01062: query has one or more manual partition(s)
ORA-38437: The ADT "string" may not contain any user methods.
ORA-30074: GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
ORA-12350: database link being dropped is still mounted
ORA-32152: Cannot perform operation on a null number