Oracle triggers are tied to PL/SQL code -- not external scripts.
The PL/SQL a trigger invokes is also limited a bit: no commits or
rollbacks and some limits on the data types it uses for variables.
Someone can prove me dumb here but I don't think this is possible.
Where's the triggering SQL being executed from?
> -----Original Message-----
> From: Anna Fong [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 6:26 PM
> To: [EMAIL PROTECTED]
> Subject: OT: triggering a script after insert/update
>
>
> 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
>
