Oracle Database Discussions

I want send the email from oracle database.
So I did the following steps
1.@F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlmail.sql

2.@F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\prvtmail.plb

3.alter system set smtp_out_server = 'webmail.vilsoft.co.in:25' scope=both;

4.exec utl_mail.send(sender=> 'Id1@vilsoft.co.in',recipients=>'Id2@vilsoft.co.in',subject=>'test mail',message=>'hi');

PL/SQL procedure successfully completed.

So the mail is send to Destination Correctly.

But When I want to send the mail from one server to another server So i execute the following query

SQL> exec utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi');

then following error occurs....

BEGIN utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi'); END;

*
ERROR at line 1:
ORA-29279: SMTP permanent error: 553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
ORA-06512: at "SYS.UTL_SMTP", line 20
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 240
ORA-06512: at "SYS.UTL_MAIL", line 424
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 1

So Please help me to resolve this error ...

Edited by: 901580 on Dec 21, 2011 2:42 AM