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