Re: How to call a C program from PL/SQL under Unix

Oracle government has a utility called PLEX that allows you to call C code from pl/sql. You can send parameters and get a return value. It has good background documentation and source code. In fact, I remember from the documentation that it uses pro*c and database pipes to do its magic, so if you already use pro*c you probably can just pull out the parts that you need (or just be safe and use the whole thing). Hope that helps.

ceid_at_wara.bolnet.bo wrote in article <868486841.7882_at_dejanews.com>...
> Hi !
>
> I have a PL/SQL stored procedure on my Oracle 7.3.2 server running on SCO
> OpenServer 5. I need to call a PRO*C program from the PL/SQL stored
> procedure and, if possible, send parameters and receive a return value.
>
> Any help will be apreciated.
>
> Thank you.
>
> Camilo Eid
> ceid_at_wara.bolnet.bo
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
>
Received on Tue Jul 15 1997 - 00:00:00 CDT