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-08231: smscre: unable to attach to SGA
ORA-02020: too many database links in use
LSX-00294: field "~S" produced multiple hits
LRM-00122: value 'string' for 'string' must be between 'number' and 'number'
DRG-10599: column is not indexed
RMAN-04005: error from target database: string
ORA-23324: error string, while creating deferror entry at "string" with error string
PCB-00626: Incompatible LOB types
ORA-19704: file name exceeds maximum length of string
ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
LPX-00104: element "~S" is not declared in the DTD
NNO-00115: line string: single-value data type "string", other instances ignored