Calling C libraries thru Stored procedure in Oracle 8...Help pls...!!

From: PRAB ATHILAT <pathilat_at_worldnet.att.net>
Date: 5 Dec 1998 00:23:29 GMT
Message-ID: <749ue1$n5j@bgtnsc03.worldnet.att.net>

This is supported in Oracle 8 only. For this I configured my listener.ora and tnsnames.ora with a problem. I'm using TCP protocol instead of IPC as given in examples.
created a shared libary in hp/ux ld /usr/ccs/lib/crt0.o sharetest.o -L ./ -a shared -ltest +b: ld -o stpexe /usr/ccs/lib/crt0.o stpsh.o -L /home/spoliske/shared -a shared -ltest +b: the shared library is confirmed to work. it can be used from c programs. on the oracle side. DROP library STPSHARE; create library STPSHARE as '/home/spoliske/shared/kshare.sl';

CREATE OR REPLACE PROCEDURE OUTPUTSTRING(p_path IN VARCHAR2, p_mesg IN VARCHAR2) AS EXTERNAL
LIBRARY STPSHARE
NAME "OUTPUTSTRING"
PARAMETERS (p_path STRING, p_mesg STRING); BEGIN
OUTPUTSTRING('/home/spoliske/shared/crap','eat crap!'); END; SQL> exec OutputString('/home/spoliske/shared/crap','eat crap!'); begin OutputString('/home/spoliske/shared/crap','eat crap!'); end; *

Here is the error message

ERROR at line 1:

ORA-28576: lost RPC connection to external procedure agent
ORA-06512: at "INVOICE.OUTPUTSTRING", line 0
ORA-06512: at line 1

28576, 00000, "lost RPC connection to external procedure agent"

// *Cause:  A fatal error occurred in either an RPC network connection,


//          the extproc agent, or the invoked 3GL after communication had


//          been established successfully.


// *Action: First check the 3GL code you are invoking, and make sure there
are


//          no network problems. Most likely, the invoked "C" routine is


//          terminating abnormally.


//          If all components appear to be normal but the problem


//          persists, this could be an internal logic error in the transfer


//          code.  Contact your customer support representative.


=====================================================

We have no other details about configuration. .Any HELP /details on this would be appreciated.
Thanks in advance

regards
Prab Athilat
Senior Database Architect
Newcourt Leasing and Capital
pathilat_at_worldnet.att.net Received on Fri Dec 04 1998 - 18:23:29 CST