Re: external procedure from trigger?

What about setting up a "demon" process that listens to a pipe (DBMS_PIPE) and write info to the pipe in your trigger?

--
Karl E. Jørgensen
Return address forged to prevent spam, use k a r l @ j o r g e n s e n . c o m instead...

Doug Cowles wrote in message <378D5C45.CCB92E81_at_bigfoot.com>...
>I would like it if I can set up e-mail through a trigger, and therefore
>paging. I have an error table in a custom app and was hoping to be
>paged whenever there was a new
>record. (Paging is done through e-mail in my case). I thought an
>external
>procedure which called a shell function or os command would do the
>trick,
>but it occurred to me that since there's no dbms_sql allowed, there may
>be no external procedures allowed either in triggers. If this is true,
>any other ideas?
>I saw a posting ealier about mucking around on Oracle's website for help
>with e-mail.
>Possible in a trigger? I guess I'm just thinking that if there is some
>sort of theoretical
>problem with committing in a trigger, it might be a problem to interface
>with the outside
>world as well.
>
>- Dc.
>
Received on Thu Jul 15 1999 - 03:45:03 CDT