This content has been marked as final. Show 5 replies
Have a look at this link
I've found the following code on this thread Re: Send Email
CREATE OR REPLACE FUNCTION send_email ( input_recipient IN VARCHAR2, input_sender IN VARCHAR2, input_subject IN VARCHAR2 DEFAULT NULL, input_message IN VARCHAR2) RETURN VARCHAR2 IS l_mailhost VARCHAR2(255) := '<MAIL HOST IP ADDRESS>'; l_mail_conn utl_smtp.connection; crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 ); l_msg_text VARCHAR2(4000); BEGIN util.get_ORACLE_constant_type_val l_mail_conn := UTL_SMTP.OPEN_CONNECTION(l_mailhost, <port>); --<port> Port UTL_SMTP.helo(l_mail_conn, l_mailhost); UTL_SMTP.mail(l_mail_conn, NVL(input_sender,'ORACLE')); UTL_SMTP.rcpt(l_mail_conn, input_recipient); UTL_SMTP.open_data(l_mail_conn ); l_msg_text := 'MAIL TEXT'; UTL_SMTP.write_data(l_mail_conn, l_msg_text); UTL_SMTP.close_data(l_mail_conn ); UTL_SMTP.quit(l_mail_conn); RETURN NULL; EXCEPTION WHEN OTHERS THENs RETURN SQLERRM; END; / BEGIN -- Call the procedure send_email(p_sender => 'ORACLE SCHEDULAR', p_recipient => 'firstname.lastname@example.org', p_subject => 'SCHEDULAR JOB', p_message => 'SCHEDULAR JOB Completed Succesfully' ); END; /
I think you are pointing to the
Job Notification Package: The job notification package enables users to setup e-mail notification for jobs .
I tried to click on the link. Seems like its a download link. Here we have restriction for direct download. Can you just provide me the exact package details. And does this package supports Oracle 10g. If so how I can install it.
Really do You need send it. I think It's more easy report error or get info. from execution using GRID CONTROL/DB CONSOLE.
Yep.. the grid control is not installed here too. So I have to set up some script or use the utl.smtp for the mail activity. So it would be great if you help in this.