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 |
SQL-02125: Connect error, can't get error text
ORA-32014: error processing parameter "string" from the SPFILE restore image
PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.
SQL*Loader-00805: %s not supported by External Table
ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
LFI-00152: Read operation (byte mode) failed.
ORA-22857: cannot modify columns of object tables
ORA-13296: incorrect coordinate system specification
NCR-04004: NCRR: Invalid interface instance handle
ORA-01529: error closing file 'string'
ORA-24330: internal OCI error
DRG-51312: DML lock internal error string