PL/SQL Procedure Send mail problem

Hi all I wrote a procedure to send email via plsql procedure, It was compiled successfully but not working ....
here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )

Code
CREATE OR REPLACE PROCEDURE send_test_message


IS


mailhost VARCHAR2(64) := 'mail.cmcltd.com';


sender VARCHAR2(64) := 'akash.sharma@cmcltd.com';


recipient VARCHAR2(64) := 'lalit.mohan@cmcltd.com';


mail_conn UTL_SMTP.connection;


BEGIN


DBMS_OUTPUT.put_line('Step:1');


mail_conn := UTL_SMTP.open_connection(mailhost, 25);


DBMS_OUTPUT.put_line('Step:2');


UTL_SMTP.helo(mail_conn, mailhost);


DBMS_OUTPUT.put_line('Step:3');


UTL_SMTP.mail(mail_conn, sender);


DBMS_OUTPUT.put_line('Step:4');


UTL_SMTP.rcpt(mail_conn, recipient);


DBMS_OUTPUT.put_line('Step:5');


-- If we had the message in a single string, we could collapse


-- open_data(), write_data(), and close_data() into a single call to data().


UTL_SMTP.open_data(mail_conn);


DBMS_OUTPUT.put_line('Step:6');


UTL_SMTP.write_data(mail_conn, 'This is a test message.' || CHR(13));


DBMS_OUTPUT.put_line('Step:7');


UTL_SMTP.write_data(mail_conn, 'This is line 2.' || CHR(13));


DBMS_OUTPUT.put_line('Step:8');


UTL_SMTP.close_data(mail_conn);


DBMS_OUTPUT.put_line('Step:9');


DBMS_OUTPUT.put_line('Step:10');


UTL_SMTP.quit(mail_conn);


DBMS_OUTPUT.put_line('Step:11');


EXCEPTION


WHEN OTHERS THEN


DBMS_OUTPUT.put_line('not executed i m in exeption ');


END;


/
Copyright GeekInterview.com

SQL> exec send_test_message
Step:1
Step:2
Step:3
Step:4
not executed i m in exeption
please advise
thanks

lalit4untl
Profile Answers by lalit4untl Questions by lalit4untl
Jan 23rd, 2007
3
2266

Questions by lalit4untl answers by lalit4untl

PL/SQL

Answer

Showing Answers 1 - 3 of 3 Answers

KiranKW
Profile Answers by KiranKW

May 2nd, 2007

Hi,

I dont see any problem with your code ... try to capture the return code for each of the calls ... that will help to identify the exact problem