Re: Running an executable from a trigger

From: Power User <david.swanson_at_sprintranet.com>
Date: Sat, 12 Dec 1998 00:56:22 GMT
Message-ID: <3672be67.175111515@nntp.sprintisp.com>

The only way I've ever seen this done is VIA the dbms_pipe package...

You would write your PL/SQL procedure to insert a value into a specific pipe in the oracle database and then have a program probably running in the background on your NT machine that monitors the Oracle pipe and when it gets a message in the pipe, acts on it... One of the actions could be to execute an external program...

Oracle itself does not seem to have this sort of functionality built into the database...

On Fri, 11 Dec 1998 20:52:13 GMT, "Dave's News" <stimpson_at_visionarysoftwareSPAM.com> wrote:

>We would like to run a Windows Executable (VC++ app) from a trigger within
>Oracle. Does anyone have an idea on how we could do this?
>
>We have Oracle 8.0.4 for NT.
>
>Thanks in advance.
>
Received on Fri Dec 11 1998 - 18:56:22 CST