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