Hi, I'm looking for an example of how to trigger a script (Perl, shell, whatever...) after an insert/update into a table. I've seen database triggers used to replicate data to other databases, but how do I trigger an external script? Currently, I have a bunch of Perl scripts that create reports in HTML from the database. Each time an insert/update is done, the scripts need to be executed in order to update the report. Right now, we're just manually running the scripts. I'd like to automate it so that the execution of the scripts is triggered from the insert/update in the database. Is this possible? Database: Oracle 8.0.3 Platform: HP-UX 10.20 Thanks in advance for you reply, Anna -------------------------------------------------------- Anna Q. Fong, Webmaster California Data Exchange Center
