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 |
DRG-50909: maximum number of documents string is not an integer
ORA-29854: keyword BITMAP may not be used in creating domain indexes
PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES
ORA-16644: apply instance not available
ORA-01667: cannot add any more tablespaces: limit of string exceeded
TNS-12150: TNS:unable to send data
ORA-01218: logfile member is not from the same point-in-time
ORA-09975: kxfspini: Error Initializing SDI Process
ORA-19400: System type conflict with object SYS.string
AMD-00160: Warning! Exceeded maximum Custom Measure number of "string"
NNL-00255: Server-generated requests now request forwarding
RMAN-20222: datafilename not found in recovery catalog or is ambiguous