Re: UNIX shell command from ORACLE

From: Gerard H. Pille <ghp_at_santens.be>
Date: 1997/09/19
Message-ID: <01bcc4f5$f0dbcea0$7b1340c0@pcghp.santens.be>#1/1

Don't think so. I would have a PRO*C program reacting on a dbms_alert generated by the stored procedure.

Kind regards,

Gerard

kestas.sereiva_at_aspentech.com schreef in artikel <874660482.26474_at_dejanews.com>...
>
> Hi all,
>
> Environment: ORACLE 7.3 on UNIX
>
> I want to create a trigger on the table that fires each time the UPDATE
> or the SELECT statement is executed on this table. The trigger would run
> a stored procedure, which, in turn, would launch the program on UNIX. How
> do I execute a UNIX command from a stored procedure?
>
> I have implemented exactly the same scenario using MS SQLServer on NT.
> The line that executed NT system command from a stored procedure looked
> like this: exec master..xp_cmdshell 'any_system_command' go
>
> Is there a similar way to execute system commands from ORACLE stored
> procedures?
>
> Thanks for the information.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Fri Sep 19 1997 - 00:00:00 CDT