Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> lost RPC connection to external procedure agent

lost RPC connection to external procedure agent

From: Swajit Satam <swajit_at_mahindrabt.com>
Date: Mon, 14 Aug 2000 20:50:37 +0530
Message-Id: <10589.114502@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US