external procedures + Pro*C

Hi,

I'm trying to make an external procedure within a DLL that reconnects to the database again ,
perform some selects, some computations and some updates.

this is the only way to do because we must use some external DLLs for financial computations,
and we must make some memory allocation and many functions calls to the financial DLLs ...
this cannot be done in PL/SQL ...

The problem is that the connection fails when trying to connect to the database from the DLL (written in Pro*C) :

the code looks like this:

EXEC SQL WHENEVER SQLERROR GOTO errexit; EXEC SQL CONNECT :username IDENTIFIED BY :password;
.......
.......

errexit:
LOG("%.70s ", sqlca.sqlerrm.sqlerrmc); sprintf(tmpbuf, "(%d)\n", sqlca.sqlcode ); LOG("%s\n", tmpbuf);
.......
.......

(LOG : a function that writes to a text file)

so the connection fails with the error message (written to a text file) :
ORA-12203: TNS:unable to connect to destination (-12203)

may be that the TNSListener is still dealing with the extproc.exe so it couldn't
handle this connection ....

Does someone have already seen this problem . How to correct this.

Any suggestions are welcome.

Thank you.

souabni@_no__spam_fermat.fr Received on Thu Mar 04 1999 - 10:15:09 CST