-
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.
kavitha s
-
Hello
Please make a search on thsi forum.
http://www.dbasupport.com/forums/sho...threadid=11060
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|