PLS-00705: exception 'string' used in expression requiring
return type
- 1 Answers
- 2851 Views
- I also Faced
- E-Mail Answers
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 |
LSX-00262: attribute "~1S" cannot have complex type "~2S"
QSM-01006: query rewrite disabled for this query block
ORA-22879: cannot use the LOB INDEX clause for partitioned tables
ORA-38404: schema extension not allowed for the attribute set name
ORA-28519: no heterogeneous data dictionary translations available
ORA-01603: illegal grouping size in clause "string" of string
ORA-16601: site contains required resources that are disabled
ORA-14120: incompletely specified partition bound for a DATE column
ORA-39092: unable to set SCN metadata for object "string.string" of type string
ORA-16017: cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
AMD-00155: Object to delete "string" does not exist in Workspace "string"
ORA-23318: a ddl failure has occurred
Oracle Errors 
