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
  1. span style="color: #F00;">'mail.cmcltd.com''akash.sharma@cmcltd.com''lalit.mohan@cmcltd.com''Step:1''Step:2''Step:3''Step:4''Step:5');

    2. 

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

    3. 

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

    4. 

  4. 'Step:6''This is a test message.''Step:7''This is line 2.''Step:8''Step:9''Step:10''Step:11''not executed i m in exeption '
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

Questions by lalit4untl   answers by lalit4untl

Showing Answers 1 - 1 of 1 Answers

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions