Tag Archives: UTL_SMTP

DECLAREc UTL_SMTP.CONNECTION; PROCEDURE send_header(name IN VARCHAR2, header IN VARCHAR2) ASBEGINUTL_SMTP.WRITE_DATA(c, name ‘: ‘ header UTL_TCP.CRLF);END; BEGINc := UTL_SMTP.OPEN_CONNECTION(‘smtp serverınız adı’);UTL_SMTP.HELO(c, ‘bilginc.com’);UTL_SMTP.MAIL(c, ‘zekeriyab@bilginc.com’);UTL_SMTP.RCPT(c, ‘zekeriyabesiroglu@google.com’);UTL_SMTP.OPEN_DATA(c);send_header(‘From’, ‘”Sender” ‘);send_header(‘To’, ‘”Recipient” ‘);send_header(‘Subject’, ‘Deneme’);UTL_SMTP.WRITE_DATA(c, UTL_TCP.CRLF ‘deneme maili’);UTL_SMTP.CLOSE_DATA(c);UTL_SMTP.QUIT(c);EXCEPTIONWHEN utl_smtp.transient_error OR utl_smtp.permanent_error THENBEGINUTL_SMTP.QUIT(c);EXCEPTIONWHEN UTL_SMTP.TRANSIENT_ERROR OR UTL_SMTP.PERMANENT_ERROR THENNULL;END;raise_application_error(-20000,‘Mail atarken … Continue reading →