PLS-00508: The expression in a RETURN statement cannot be a type
Answer / guest
Cause: A datatype specifier was used instead of an
expression in the RETURN statement of a user-defined
function, as shown in the example below. Do not confuse the
RETURN statement, which sets the function identifier to the
result value, with the RETURN clause, which specifies the
datatype of the result value. FUNCTION credit-rating
(acct_no NUMBER) RETURN BOOLEAN IS BEGIN ... RETURN NUMBER;
-- should be an expression END;
Action: Replace the datatype specifier in the RETURN
statement with an appropriate expression.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02399: exceeded maximum connect time, you are being logged off
ORA-12845: failed to receive interinstance parallel execution message
ORA-39018: master process received invalid message number string
ORA-32005: error while parsing size specification [string]
ORA-15102: invalid POWER expression
SQL*Loader-00488: %s not a named collection type for filler field string
ORA-12671: Shared server: adapter failed to save context
PLS-00385: type mismatch found at 'string' in SELECT...INTO statement
ORA-30018: Create Rollback Segment failed, USN string is out of range
ORA-09819: Number exceeds maximum legal value
ORA-12438: repeated policy option: string
ORA-28590: agent control utility: illegal or badly formed command