Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Running OS command from Oracle

Re: Running OS command from Oracle

From: Shannon R. Madsen <madsen_at_cs.umn.edu>
Date: 1996/12/20
Message-ID: <59evi8$rd@epx.cis.umn.edu>#1/1

Igor Pomazanov <mbwt_at_glas.apc.org> writes:

>Can somebody help me to find a way to run OS command from Oracle.
>For example after changing of certain data I need to send a message to printer.

AFAIK, the only way to do this is to write the commands to a table, then have a program or script periodically check for entries in that table (via cron or some other scheduler) and execute them.

If anyone has a better idea, I'd love to hear it!

-Shannon

--
Shannon Robert Madsen                                       madsen_at_cs.umn.edu
=============================================================================
   http://www.cs.umn.edu/~madsen      |       "ad astra per aspera"
=============================================================================
GAT d(-) s+:- a21 C+++$ USBAILXH++++$ P+++$ L+ E+ W+++$ N+++$ o? K++
w---$ O? M++$ V-- !PS !PE Y PGP+ t+++ 5++ X++ R- tv b++ DI++++ D+ !G e
h++(-)* r%* y+ 
Received on Fri Dec 20 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US