Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> lost RPC connection to external procedure agent
Hi,
I have listed below the errors that occured while calling the external routine.
ORA-28576: lost RPC connection to external procedure agent ORA-06512: at "MBT_CDD.PKG_REG", line 0 ORA-06512: at "MBT_CDD.TEST_REG", line 9 ORA-06512: at line 1
Our methodology is as follows:
We have created a .so file say liba.so. The object files that comprises
this .so are acpgm.o and acpppgm.o. The former is a
C file and the latter is a C++ file. The C pgm makes a function call to
the C++ pgm. The C pgm is in turn invoked by a
PL./SQL procedure as an external routine. The C++ then does some
processing and then returns the control to C which in
turn returns the control back to PL/SQL.
Our Problem : The problem we are facing is in calling the C pgm from the
PL/SQL. We got hold of some
oracle documentation from the Oracle Metalink Site. Based on the
instructions given we again tried modifying the code and
call the C pgm. But we were unsuccessful. The error ORA - 28576 has been
reproduced below.
ORA-28576 lost RPC connection to external procedure agent
Cause: A fatal error occurred in either an RPC network connection, the external procedure agent, or the invoked 3GL after communication had been established successfully.
Action: First check the 3GL code you are invoking; the most likely cause of this error is abnormal termination of the invoked "C" routine. If this is not the case, check for network problems. Correct the problem if you find it. If all components appear to be normal but the problem persists, the problem could be an internal logic error in the RPC transfer code. Contact Oracle Customer Support.
We have also tried calling the .so file from an independent C executable and it is working fine. So our guess is that there is some problem with the internal logic of Oracle. Received on Mon Aug 14 2000 - 10:20:37 CDT