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-12918: Invalid tablespace type for default permanent tablespace
ORA-02315: incorrect number of arguments for default constructor
ORA-09835: addCallback: callback port is already in a set.
ORA-12062: transaction string received out of sequence from site string
ORA-07484: snlkput: cannot convert(put) lock.
NID-00304: Datafile string - reverted
TNS-12532: TNS:invalid argument
ORA-00991: only MAC privileges may be granted to procedures
TNS-00061: INTCTL: Bad command or syntax error: You must specify a trace level
ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
ORA-23314: database is not a materialized view site for "string"."string"
NID-00140: Specified database name string does not match previous name used string