Dear Exparts,
My Oracle Database 10g R2 version Release 10.2.0.1.0
I'm trying to send mail via UTL_MAIL.SEND. For this what i done..?
1. Connect database as SYS dba
2. successfully run the two things 1.ORACLE_HOME/rdbms/admin/utlmail.sql, 2. ORACLE_HOME/rdbms/admin/prvtmail.plb
3. set smtp_server information by
alter system set smtp_out_server = '172.25.90.165:25' scope=both;
4. SHUTDOWN IMMEDIATE
then
5. startup
all done successfully.
Checked the mail server connectivity by telnet smtp_ip port ...and success.
Run the following code
EXEC UTL_MAIL.SEND(SENDER => 'etl_demo2@mydomain.com',RECIPIENTS => 'etl_demo1@mydomain.com',
SUBJECT => 'Testing UTL_MAIL Option',message => 'blah blah blah');
the out put is
ERROR at line 1:
ORA-29279: SMTP permanent error: 555 syntax error (#5.5.4)
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 222
ORA-06512: at "SYS.UTL_MAIL", line 407
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2
Search on Google for this issue and failed do anything..
Any help will appreciated
Ask to Learn