Discussion on:

Message 9 of 9
0 Votes
+ -
RE: Sending e-mail from an Oracle database with utl_smtp
Hi everyone,

I have created the stores procedured, and configure them, but when I execute, I got the next error:

Error report:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 374
ORA-06512: at "CEOADMIN.SP_ENVIARCORREOALERTASVENCIDAS", line 28
ORA-29279: SMTP permanent error: 530 5.7.0 Must issue a STARTTLS command first. 13sm4958418gxk.5
ORA-06512: at line 14
29278. 00000 - "SMTP transient error: %s"
*Cause: A SMTP transient error occurred.
*Action: Correct the error and retry the SMTP operation.
Posted by shahmat
3rd Feb 2010