Calling External Procedures from PL/SQL

I'm trying to call a c function from a shared library that I have written using Oracle 8.0.5 on HP-UX environment.

I would like to inform you about the history of my work: First of all I have tried to call the function that have no return and OUT parameter such as "void myfunc(char *, char *);" and there is no problem calling this type of external procedures.

Then, I have tried to call a function which has a return parameter such as " int myfunc(char *, char *);" and this also works correctly.

However, if the function has OUT parameter there is a problem. I have read the documentation about external procedures and applied to my code. I do not want to use OCI but I have faced with an OCI error. Is it possible to call an external procedure with OUT parameters without using OCI?

Function Prototype :
int MyFunction(char *, char *, char *);
// the 1st and 2nd arguman are IN parameters
// the 3rd arguman is OUT parameter

Error Messages:
ORA-28577: argument 4 of external procedure MyFunction has unsupported datatype OCINumber

ORA-06512: at "M.MYFUNCTION", line 0
ORA-06512: at "M.P_MYFUNCTION", line 12
ORA-06512: at line 2

Thanks in Advance,
Emine Received on Mon Jun 25 2001 - 09:59:50 CEST