Home » Developer & Programmer » Forms » ERROR IN SENDING EMAILS FROM A FORM (6i)
ERROR IN SENDING EMAILS FROM A FORM [message #439894] Tue, 19 January 2010 23:29 Go to next message
AHMADF124
Messages: 30
Registered: January 2008
Location: KSA
Member

Dear All,
Am facing a problem in sending an email to certain group of people, if the recipient just one person it will work but if more it will not work, I tried to read every one as a single recipient through a cursor but it was not working, the following is the sending code:
v_mail=:control.test;
mail_pkg.send
        ( p_sender_email => 'test@test.com',
          p_from => 'test@test.com',
          p_to => mail_pkg.array(V_MAIL),
          p_cc => mail_pkg.array('test@test.com'),
          p_bcc => mail_pkg.array( 'test@test.com'),
          p_subject => 'test',
          p_body =>('Dear Recipient,'
          					||chr(13)||
          					' New Doc received, you can open it through clicking on below link:'
          					 ||chr(13)||
          					          					 ||chr(13)||
          					 'Document information as follow:'
          					 ||chr(13)||
          					 'Doc#:'||MISS
          					 ||chr(13)||
          					 'File Type:'||:filetype
          					 ||chr(13)||
          					 'File Ref:'||:fileref
          					 ||chr(13)||
          					 'Subject:'||:subject
          					 ||chr(13)||
          					 'Company:'||:company
          					 ||chr(13)||
          					 'From:'||:fromwhom
          					 ||chr(13)||
          					 chr(13)||
          					 
          					 'This is a notifiaction email sent from system, plese Do-Not-Reply.'
          ||chr(13)||
          chr(13)||
          'Regards,,,'));
       
  end;  


:control.test data is quotes between to quotes for each address.


Regards,,,
icon7.gif  Re: ERROR IN SENDING EMAILS FROM A FORM [message #440424 is a reply to message #439894] Sun, 24 January 2010 06:57 Go to previous messageGo to next message
AHMADF124
Messages: 30
Registered: January 2008
Location: KSA
Member

Hello everybody, can you help me in resolving this problem.
Re: ERROR IN SENDING EMAILS FROM A FORM [message #445443 is a reply to message #440424] Mon, 01 March 2010 23:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

Look at utl_mail documentation. Search Oracle for 'B14258-01'. The documentation says "recipients - The email addresses of the recipient(s), separated by commas."

How are you separating them?

David
Previous Topic: Data Block using query
Next Topic: FRM-41211 and FRM-40738
Goto Forum:
  


Current Time: Tue Dec 06 00:22:59 CST 2016

Total time taken to generate the page: 0.14434 seconds