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

ORA-07598: spwat: $SETIMR failure

1 Answers  

---

PCC-02449: Cannot type equivalence a UCS2 type

1 Answers  

---

ORA-30681: improper value for argument EXTENSIONS_CMD_SET

1 Answers  

---

ORA-22856: cannot add columns to object tables

2 Answers  

---

RMAN-10006: error running SQL statement: string

1 Answers  

---

ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

1 Answers  

---

ORA-01898: too many precision specifiers

1 Answers  

---

QSM-01018: single table materialized join view rewrite not required

1 Answers  

---

RMAN-06413: channel string does not support proxy copy

1 Answers  

---

ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string

2 Answers  

---

DRG-11221: Third-party filter indicates this document is corrupted.

1 Answers  

---

QSM-01084: materialized view, string, has anchor, string, not found in query

1 Answers  

---