Re: PL/SQL -> Pro*C Function

"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.

This is not supported within PL/SQL. The problem is related to the fact that Oracle kernel will execute the code and there will be a major security problem if you would be able to link your own kernel. The problem may be solved by using package DBMS_PIPES. See PL/SQL Users Guide 2.2 for examples of using this package.

Erik Forslund
IFS R&D
erfo_at_lkp.ifsab.se Received on Mon Apr 15 1996 - 00:00:00 CEST