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-31401: change source string is not an existing change source

1 Answers  

---

ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

1 Answers  

---

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers  

---

TNS-00032: INTCTL: internal NS error

1 Answers  

---

ORA-12854: Parallel query is not supported on temporary LOBs

1 Answers  

---

ORA-00021: session attached to some other process; cannot switch session

1 Answers  

---

PLS-00336: non-object-table "string" illegal in this context

1 Answers  

---

NNL-00524: Replaces a data item with another data item

1 Answers  

---

QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph

1 Answers  

---

SQL*Loader-00481: HIDDEN may not be used with non-scalar fields.

1 Answers  

---

ORA-02265: cannot derive the datatype of the referencing column

1 Answers  

---

TNS-00295: Navigator: Security is enabled, you cannot STOP the Navigator

1 Answers  

---