Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> external procedure from trigger?
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.