Answer / guest

Cause: RETURN specification for the actual function return,
used within the parameters clause must hold the very last
position. Example : The following will give this error since
the RETURN specification for the actual function return in
the parameters clause is not the last. FUNCTION
myexternalfunc (var1 BINARY_INTEGER, var2 BINARY_INTEGER)
RETURN BINARY_INTEGER IS EXTERNAL NAME "myexternalfunc"
LIBRARY somelib PARAMETERS (var1 LONG, var2 SHORT, RETURN
INT, RETURN INDICATOR SHORT); The correct syntax is the
following. Note that RETURN for actual function return is
the last specification in the parameters clause. FUNCTION
myexternalfunc (var1 BINARY_INTEGER, var2 BINARY_INTEGER)
RETURN BINARY_INTEGER IS EXTERNAL NAME "myexternalfunc"
LIBRARY somelib PARAMETERS (var1 LONG, var2 SHORT, RETURN
INDICATOR SHORT, RETURN INT);

Action: Correct the syntax of the RETURN specification in
the parameters clause

Please add more information about this Error

ORA-07479: scgcmn: cannot open or convert lock.

1 Answers  

---

ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  

---

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers  

---

ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]

1 Answers  

---

ORA-28151: more than one user name specified for command

1 Answers  

---

ORA-01115: IO error reading block from file string (block # string)

1 Answers  

---

DRG-11840: Not Implemented

1 Answers  

---

ORA-26103: V6 or V7 data file used to create control file

1 Answers  

---

PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 Answers  

---

ORA-39147: cannot migrate Data Pump queue table ownership to this instance

1 Answers  

---

ORA-24090: at least one protocol must be enabled

1 Answers  

---

ORA-01451: column to be modified to NULL cannot be modified to NULL

1 Answers  

---