ORA-28575:<unable to open RPC connection to external procedure agent> - error when executing external procedure from PL/SQL

Hi,

We are running Oracle 8.0.4 on HP-UX 11. One of our requirements is to fetch data from a mainframe database and update our Oracle database. To test the proof of concept, we wrote a C program, built it into a .sl library, defined it as a LIBRARY in ORACLE and created a stored procedure referencing the EXTERNAL C procedure (as defined in the books). We also modified our TNSNAMES and LISTENER to add an entry for the EXTPROC process that the external procedure call goes thro'. But when executing the procedure we get this error message and we have been stuck on this problem for the past four days. And I must get it to work within the next one or two days or my **** is on the line. Somebody please help. We have been in touch with ORACLE online support all this time trying to fix this problem. But no luck.

Thanks,

Srini.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 18:27:07 CST