Re: Running an external process from a trigger?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 18 Nov 1999 09:48:15 -0500
Message-ID: <fRE0OFwQcaU5gAZpZh5tDkgOWfA9@4ax.com>

A copy of this was sent to Darren Lewis <lewisd_at_dslsys.demon.co.uk> (if that email address didn't require changing) On Thu, 18 Nov 1999 09:40:53 +0000, you wrote:

>In SQL Server I can start an external process using the xp_cmdshell
>extended stored procedure.
>
>How can I do this in Oracle?
>

In Oracle8.0 they are called EXTPROCs (external procedures -- see the plsql documentation).

In Oracle8i you can use extprocs or just use a java stored procedure to run an os command.

>I would like to start an application from a trigger which pulls
>information from the database and generates a report.
>
>Many Thanks
>Darren Lewis

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 18 1999 - 08:48:15 CST