PLS-00508: The expression in a RETURN statement cannot be a type



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

Post New Answer

More Oracle Errors Interview Questions

ORA-27044: unable to write the header block of file

1 Answers  


ORA-23608: invalid resolution column "string"

1 Answers  


DRG-10501: invalid stopword: string

1 Answers  


ORA-16622: Two or more broker database objects resolve to one physical database.

1 Answers  


ORA-37114: OLAP API bootstrap error: (string)

1 Answers  






PLS-01403: Comment delimiters /* */

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


PCC-02364: Host struct and its indicator must have the same number of fields

1 Answers  


ORA-25202: invalid value NULL, string should be non-NULL

1 Answers  


RMAN-06542: file string is excluded from whole database backup

1 Answers  


ORA-28154: Proxy user may not act as client 'string'

1 Answers  


QSM-00515: operation cancelled by user

1 Answers  


Categories