-
Hi all:
I want to send an email when a table is modified, so I create a trigger, now the problem is that I can not use de UTL_SMTP package for sending the email, because the Oracle (8.0.5)does not support it.
I am trying to execute an operating system call to send the email. But I can not find how to make a system call from the trigger or from a strore procedure.
Can anyone help me??
Thanks,
Ana
-
U can try this
From the trigger put the information to be mailed in a text file usind UTL_FILE.
Hope u mail those text files from operating system.If ur OS is unix use sendmail.
-
Hello
Please make a search on thsi forum.
http://www.dbasupport.com/forums/sho...threadid=11060
regards
Hrishy