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

PROC-00102: Cluster services error

1 Answers  

---

RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby controlfile copies

1 Answers  

---

ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

1 Answers  

---

EXP-00031: Arraysize not in valid range. Using arraysize=number

1 Answers  

---

ORA-00084: global area must be PGA, SGA, or UGA

1 Answers  

---

ORA-32059: deadlock detected on mapping structures

1 Answers  

---

ORA-16006: audit_trail destination incompatible with database open mode

1 Answers  

---

LSX-00160: invalid substitution group affiliation between "~S" and "~S"

1 Answers  

---

ORA-15021: parameter "string" is not valid in string instance

1 Answers  

---

ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  

---

PLS-01402: Use of quoted identifier

1 Answers  

---

PCB-00627: Host variable is not of character type

1 Answers  

---