Home -> Usenet -> comp.databases.oracle -> Re: system calls from within Oracle stored procedure

Re: system calls from within Oracle stored procedure

From: Carlos Augusto Leite Netto <cnetto_at_cps.softex.br>
Date: 1996/01/02
Message-ID: <4ca89p$5ik_at_tiete.dcc.unicamp.br>#1/1 







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
Received on Tue Jan 02 1996 - 00:00:00 CET












Original text of this message