I have a requirement whereby I need to have a net send message sent to a particular terminal when a specific value is inserted in a table.

A rough example would be say you have a table that tracks order and one of the columns is quantity. Since some items are frequently out of stock, you want to be notified any time a record is inserted into this table with more than quantity 'x'. I can see creating a trigger to check for this condition, but I am lost from there.

What I would like to do is say an order is inserted for 100 items, and I want my trigger to fire for any record where a quantity is greater than 50, so I create a trigger to call something (package,procedure,external prog?) to perform my net send. The purpose of this whole exercise would be to alert me that a "large" order (humor me here) has been placed.

My question is this: is there some facility in Oracle that would allow me to do this without extensive coding? I can create a simple SQL that has a host command in it that does the net send, and that is accomplished easily enough, but my quandry is how to I get the trigger to run the SQL file? If anyone has a link or some sample code to do this it would be greatly appreciated!

BTW, the db will be Oracle 8.1.7, and the OS will be Win2k or NT.

Thx,
Ray