-
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
Santosh
-
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.
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
|