send a mail from pl/sql

hi all


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???

thanks

Hi fmedina,

You can use the following in your pl/sql block to send mail

utl_smtp(.....);

check on the proper syntax from the documentation

Regards

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.