hi, my daily mail thru oracle was working fine till 3 days back..
i hav put them in dbms_job ... and every day i get mail thru it ... it was
really superb
but since last 3 days i m getting following :

SQL> exec daily_mail;
BEGIN daily_mail; END;

*
ERROR at line 1:
ORA-20001: 451 Unable to complete command, DNS not available or timed out
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 204
ORA-06512: at "SYS.DAILY_MAIL", line 42
ORA-06512: at line 1

can anybody help ?

Deepa



Oracle LazyDBA home page