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-27044: unable to write the header block of file
ORA-23608: invalid resolution column "string"
DRG-10501: invalid stopword: string
ORA-16622: Two or more broker database objects resolve to one physical database.
ORA-37114: OLAP API bootstrap error: (string)
PLS-01403: Comment delimiters /* */
ORA-19719: length for operation name longer than string
PCC-02364: Host struct and its indicator must have the same number of fields
ORA-25202: invalid value NULL, string should be non-NULL
RMAN-06542: file string is excluded from whole database backup
ORA-28154: Proxy user may not act as client 'string'
QSM-00515: operation cancelled by user