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??
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.
Please make a search on thsi forum.
Click Here to Expand Forum to Full Width