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 |
LPX-00219: invalid digit '~c' in character reference
NNO-00613: disabling FORWARDING-DESIRED on system queries
PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument
NPL-00419: received ASN.1 object identifier with sub-identifier that is too large
RMAN-06128: skipping inaccessible file string
RMAN-05010: target database must be opened in READ WRITE mode for TSPITR
RMAN-08538: channel string: no autobackup in string days found
PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode
NID-00131: Control file is not current
ORA-09928: Unable to restore the label of server
SQL*Loader-00408: Physical record stack overflow
ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string