Re: Calling 'C' routines from Stored Procedures
Date: 1996/05/24
Message-ID: <4o3b6m$83h_at_tracy.protocom.com>#1/1
In article <4o0eui$5ac_at_engnews2.Eng.Sun.COM> mdalmia_at_metrics1.eng.sun.com (Manish Dalmia) wrote:
> I want to know whether 3GL routines can be called from stored procedures.
> If so, how ?
>
> Thanks
>
>
>
The only way I know of is to use the dbms_pipe package. First
set up the stored procedure to write to a named pipe the name
of the executable to start up and the parameters. Next, create
an OCI program to read the named pipe and spawn the
requested procedure. In $ORACLE_HOME/rdbms/demo there is
an example program called dbms_pipe.c that is a good place
to start. It is an example of reading a named pipe and sending
the output to the screen (the example deals with debugging
stored procedures).
Hope this helps,
Mark
That which does not kill us only serves to make us stronger, or something like that. Received on Fri May 24 1996 - 00:00:00 CEST