Xref: alice comp.databases.oracle.server:74641 Path: alice!news-feed.fnsi.net!enews.sgi.com!paloalto-snf1.gtei.net!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Thomas Kyte Newsgroups: comp.databases.oracle.server Subject: Re: Running an external process from a trigger? Date: Thu, 18 Nov 1999 09:48:15 -0500 Organization: Oracle Service Industries Lines: 31 Message-ID: References: Reply-To: tkyte@us.oracle.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: inet16.us.oracle.com 942936498 16626 138.1.114.200 (18 Nov 1999 14:48:18 GMT) X-Complaints-To: usenet@inet16.us.oracle.com NNTP-Posting-Date: 18 Nov 1999 14:48:18 GMT X-Newsreader: Forte Agent 1.6/32.525 A copy of this was sent to Darren Lewis (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@us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle Corporation