Re: Calling a C routine from PL/SQL program

On UNIX, Oracle offers and example PRO*C program that helps do this (using pipes). We used that for a while, but ran into problems with it and Oracle 7.2.2.3.

What we currently do is a little less efficient, but works well. We have created a table that we insert external program calls into. We then have a C program that checks the table at a certain interval for new records, when it finds them, it executes the commands. This solution would work on NT as well as UNIX.

My humble opinion is that Oracle needs to address this in a cleaner manner.  They should support calling the O/S from PL/SQL.

-- 

+---------------------------------------+-------------------------------+
| David Kaiser                          | e-mail: davidk_at_sfmic.com      |
| Project Manager                       |    WWW: http://www.sfmic.com  |
| State Fund Mutual Insurance Company   |                               |
| 7500 Flying Cloud Drive, Suite 900    |  voice: 612.914.1317          |
| Eden Prairie, MN 55344  USA           |    fax: 612.944.1169          |
+---------------------------------------+-------------------------------+


Alex B. Danchenkov <dabr_at_leaves.spb.su> wrote in article
<01bc7bb7$8ac13240$232b7dc1_at_dabr>...


> Hello!

> There is a little PL/SQL related question.

> Is there any way to call a C routine from stored PL/SQL program on

 database


> server side?

> I have Oracle7 Server v7.3.3 for Win NT 4.0.

> Thanks in advance

> ----------------------------------------------

> Alex B. Danchenkov, Certified Oracle DBA,Leaves Inc.

> dabr_at_leaves.spb.su

> 

>