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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help - daemon.pc

Re: Help - daemon.pc

From: David Kaiser <davidk_at_sfmic.com>
Date: 1997/01/14
Message-ID: <32DBAE32.67B@sfmic.com>#1/1

We have it, but I don't recommend using it. There is a bug in the version we have that causes a lock on some system tables. Oracle support wasn't too happy that we were running it.

We have instead added a program that runs in cron every 5 minutes. It queries a table that triggers can insert into. The program runs commands out of that table.

Oracle should be slapped for not allowing UNIX commands to be easily called from triggers.

-- 

+---------------------------------------+-------------------------------+

| David Kaiser | e-mail: davidk_at_sfmic.com
|
| Project Manager | WWW: http://www.sfmic.com
|
| State Fund Mutual Insurance Company |
|
| 7500 Flying Cloud Drive, Suite 900 | voice: 612.914.1317
|
| Eden Prairie, MN 55344 USA | fax: 612.944.1169
|
+---------------------------------------+-------------------------------+
Received on Tue Jan 14 1997 - 00:00:00 CST

Original text of this message

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