Re: After-Insert-Trigger must call external application

Have you thought about a scheduled job instead of a trigger? If your table experiences a high volume of inserts, this trigger will fire many, many times. And spawning the external process will only add to the trigger execution time. It might be better to write a job which runs every so often (1 hour?) and does what you need to the data. Just a thought....

Aside from external routines, you could also use Java Stored Procedures.

HTH,
Brian Received on Thu Oct 31 2002 - 08:08:15 CST