Re: Triggers and OS's

I take it that you need to perform the action from within the RDBMS rather than from a client connection through SQL*Plus or the equivalent otherwise you wouldn't be asking this question.

There are a number of ways of doing this. The simplest and most convenient way is to write a daemon process in Pro*C that connects to the RDBMS and registers for a DBMS ALERT. You can then asynchronously and very efficiently signal you daemon to do the O/S side work for you. The work involved for something as you describe is trivial.

A dumber approach is to write a shell script calling SQL*Plus periodically that polls the db for a flag in a table somewhere that indicates that the action should be taken. Polling the db like this is not a good practice. This is very inefficient from both the process creation point of view and the effect on the RDBMS buffer cache.

...neil [Actually: neil_hulin_at_hotmail.com] Received on Wed Nov 11 1998 - 07:28:16 CST