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-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
PLS-01417: Use of %%attribute
ORA-02145: missing STORAGE option
ORA-01757: Must specify an object number
ORA-33218: (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV
ORA-40204: model string already exists
ORA-01252: cannot prevent writes - file string in recovery manager backup
IMG-00530: internal error while parsing command
ORA-31469: cannot enable Change Data Capture for change set string
ORA-29885: domain index is defined on the column to be modified
ORA-07625: smsget: $MGBLSC failure