Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00705: exception 'string' used in expression requiring
return type
- 1 Answers
- 3264 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 |
ORA-01218: logfile member is not from the same point-in-time
ORA-14513: partitioning column may not be of object datatype
ORA-07249: slsget: open error, unable to open /proc/pid.
ORA-24073: cannot specify RETENTION_TIME on exception queue string.string
ORA-21612: key is already being used
PCC-02044: CMD-LINE: Illegal or out of range value for option:
ORA-13449: GeoRaster metadata ULTCoordinate error
NNL-01055: Requests received: number
ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch
ORA-39027: wrong version of master table
ORA-29818: column name not properly specified
TNS-00134: Missing COMMUNITY component in addresses for the Navigator in TNSNAV.ORA
Oracle Errors 
