Send mail with UTL_MAIL

How to send mail with with UTL_MAIL

1. first you need to contact us to get acl opened. Please include all your users/schemas that needs to access this package.

use the following sample to send mail:

 

BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1''';
UTL_MAIL.send(sender => 'me@address.com',
recipients => 'you@address.com',
subject => 'Test Mail',
message => 'Hello World',
mime_type => 'text; charset=us-ascii');
END;
/
  • 0 کاربر این را مفید یافتند
آیا این پاسخ به شما کمک کرد؟

مقالات مربوطه

How to create an Oracle Wallet?

In order to secure your domain you need to the following:  We complete all necessary...

Can one read/write files from PL/SQL?

Please contact revion.com first, so we can enter directory into oracle config....

What is PL/SQL and what is it used for?

PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL's language syntax, structure and...

What are the steps to buy SSL certificate?

This is what you need to do:1. Please ensure your whois info (registrar) info is...