Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> external procedure from trigger?

external procedure from trigger?

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 14 Jul 1999 23:57:57 -0400
Message-ID: <378D5C45.CCB92E81@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.

Received on Wed Jul 14 1999 - 22:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US