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-39308: application/database upgrade internal error: "string"
ORA-03231: the INITIAL extent may not be deallocated
ORA-16752: Resource guard could not mount standby
ORA-32100: operation invalid on transient object
ORA-19764: database id string does not match database id string in control file
PCC-02129: CMD-LINE: Client supplied static options table is invalid
LPX-00275: can't set output/data encoding AFTER parsing
ORA-39754: FULL PARTITIONED OUTER JOIN is not supported
NCR-03008: NCRO: Call rejected
ORA-32696: HTI: No free slot
DRG-12800: Attribute NESTED_TYPE must have owner name as prefix
ORA-19726: cannot plug data [string] at level string into database running at compatibility level string