Re: Calling OS executables from within a stored procedure

From: Lawrence Simela <lsimela_at_cix.compulink.co.uk>
Date: 1997/07/01
Message-ID: <ECnv32.3qH@cix.compulink.co.uk>#1/1

>>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. Received on Tue Jul 01 1997 - 00:00:00 CDT