Maybe I prove myself dumb ...
It appears to be possible, although perhaps not built in or
easy. Here's are some threads from www.orafaq.org that explain
how to do it:
http://www.orafaq.com/faqplsql.htm (a little over halfway down)
http://www.orafaq.com/msgboard/sql/messages/288.htm
http://www.orafaq.com/msgboard/server/messages/2302.htm
http://www.orafaq.com/msgboard/plsql/messages/267.htm
http://www.orafaq.com/msgboard/sql/messages/3864.htm
> -----Original Message-----
> From: Steve Sapovits
> Sent: Tuesday, March 27, 2001 6:21 PM
> To: 'Anna Fong'; [EMAIL PROTECTED]
> Subject: RE: triggering a script after insert/update
>
>
>
> 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
> >
>
