i'm using oracle aplication server as web server, a oracle database to save the data. both are in the same saver, it have solaris 8, have configured a sendmail too.
how may i send a mail from pl/sql??, not from a link on html, send a mail when a register is input or when the data change???
You can use the following in your pl/sql block to send mail
check on the proper syntax from the documentation
Inorder to send an email thru the plslq block u can either use utl_tcp or utl_smtp package. These packages have been tested and they do work fine.
Click Here to Expand Forum to Full Width