Re: PL/SQL -> Pro*C Function
Date: 1996/04/24
Message-ID: <4llfva$7ob_at_netope.harvard.edu>#1/1
"Barry L. Johnson" <bjohnson_at_csdejolt.ddc.cio.eds.com> wrote:
>Is it possible to call a Pro*C function from a PL/SQL Stored Procedure? I
>know it is possible to call a user_exit from a
>SQL*Forms application. I need to do it from a Stored Procedure (or package,
>or trigger), is it possible? For example, if I
>need to call a third party function from a insert trigger.
>
>Thanks in Advance.
Unfortunatly it's not possible as of right now. PL/SQL proceedures run on behalf of the server, not the user process. Because of this, they do not have access to the users process space, and can't start any executables. I recommend that you explore database pipes and write a server program to execute various routines in response to commands sent down the pipe. I did this a few years ago to handle printing requests from forms.
Chris
Chris Cebelenski CH: cebelenski_at_a1.tch.harvard.edu Applications Specialist Portal: cpc_at_shell.portal.com Children's Hospital Home: cpc0000_at_ibm.net#include <std_disclaimer.h> Wk Phone:(617) 355-8401 Received on Wed Apr 24 1996 - 00:00:00 CEST