Re: Calling OS executables from within a stored procedure

Lawrence Simela wrote:
>
> >>Does anyone know a good way to call an external program from
> >>within a stored procedure and receive a response? I know that
> >>I could probably use DBMS_PIPE. I'm just not sure how to
> >>block other writers to the pipe before I read the response.
> >>This external program will be called fairly often so >>concurrency and
> performance will be an issue.
>
> >>Any ideas are greatly appreciated.
>
> One way you could possibly do this is by using signaling and alerters.
> Your external program could 'sleep' until required and then be signaled
> from PL/SQL when required,... your two processes could then comunicate
> via tables, or PL/SQL tables even, to exchange data. See Application
> Programmers Guide..
>
> Regards
> Lawrence Simela
> Mahalini Consulting Limited.

Might also want to check out PLEX (PL/SQL Extender) at:

http://tiburon.us.oracle.com/odp/archive/library/util.htm Received on Thu Jul 03 1997 - 00:00:00 CDT