Posts

Showing posts from January 10, 2013

Oracle 10g/11g :Send Daily mail of Alert log to specified users or DBAs

Image
1.Create Stored Procedure send_mail to send mail with attachment. CREATE OR REPLACE PROCEDURE send_mail (p_to          IN VARCHAR2,                                        p_from        IN VARCHAR2,                                        p_subject     IN VARCHAR2,                                        p_text_msg    IN VARCHAR2 DEFAULT NULL,                                        p_attach_name IN VARCHAR2 DEFAULT NULL,                                        p_attach_mime IN VARCHAR2 DEFAULT NULL,                                        --p_attach_blob IN BLOB DEFAULT NULL,                                        p_smtp_host   IN VARCHAR2,                                        p_smtp_port   IN NUMBER DEFAULT 25) AS   l_mail_conn   UTL_SMTP.connection;   l_boundary    VARCHAR2(50) := '----=*#abc1234321cba#*=';   l_step        PLS_INTEGER  := 24573; BEGIN   l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);   UTL_SMTP.helo(l_mail_conn, p_smtp_host);   UTL_SMTP.mail