Re: system calls from within Oracle stored procedure

Carlos Augusto Leite Netto <cnetto_at_cps.softex.br> wrote:
>chuck_at_metronet.com (Charles C. Williams) wrote:
>>How can I call a C program with input parameters from within an Oracle
>>stored procedure and have that program return parameters and then proceed
>>with the remainder of the PL/SQL in that stored procedure?
>>
>>Supposedly, there is a release of PL/SQL coming out that has this option,
>>but there must be a current work around or some viable alternative to
>>waiting for the release.
>
>That's an old issue. You can find many many PL/SQL programs calling
>RDBMS's internal peaces of C code using an "interface "C"" statement,
>not available to us. I don't know if Oracle is going to open this
>feature for us, sorry.
>
>Well... you can write a "C" program that stays listening to a Oracle
>Pipe; this program itself can make the system call when receives some
>specific message on the pipe, delivering the result across other pipe.
>Sorry again: I don't know an easier way.
>
>Regards,
>
>Carlos Netto
>cnetto_at_cps.softex.br
>
There is a C program you can get from Oracle to do this. If you would like a copy, e-mail me (kedenny_at_mail.concentric.net) and I can e-mail you a copy.

Regards
Ken Denny
Insight Industries, Inc.
RTP, NC Opinions expressed are my own and not my employer's. Received on Tue Jan 02 1996 - 00:00:00 CET