Re: How to call C program or C functions from PL/SQL ?

>Hello,
>
>Is it possible to call C program or C functions from PL/SQL ???
>
>Examples ??

Basically this is not possible, at least not directly. What we did was the following:

A program written in C using the Pro*C-Compiler called a PL/SQL-routine inside the database which does just look in a pipe for incoming messages by using the dbms_pipe package. As soon as a command arrives at the specified pipe the command is taken and executed by the C-Program.

Well, the normal PL/SQL-routine, which constantly runs inside the database then wants to call this C-program outside the database. It then simply writes the correct command to the specified pipe and awaits the return code at the return pipe. Quite complicated, but it works.

It's up to you to define the pipes, to define the possible commands, to define the syntax of the commands, to define the return port pipe and to define all other components...

Best regards,

   Martin Pfingstl

mpfingstl_at_lhsystemsas.de Received on Tue Jul 06 1999 - 10:12:02 CDT