send email from Oracle 10g
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',
'test',
'test','test');