PL/SQL (MOSC)

MOSC Banner

send email from Oracle 10g

edited May 9, 2011 3:46AM in PL/SQL (MOSC) 7 commentsAnswered
Hello all,

i am trying to send email from trigger , i followed the below steps to do that :

SQL> connect sys/password as sysdba
Connected.

 SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql

Package created.

Synonym created.

SQL> @$ORACLE_HOME /rdbms/admin/prvtmail.plb

Package body created.

No errors.

then i configured the SMTP :

alter system set smtp_out_server = '<ip-address:port' scope=Both;

i tried to ping & telnet the ip address of smtp and it works just fine

now when i execute the below procedure :

SQL> exec UTL_MAIL.send('xxxxxxxx@xxxxx.xxx',

                                                  yyyyyyy@yyyyyyyy.yyyy',

                                                  'test',

                                                  'test','test');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center