ERROR IN SENDING EMAILS FROM A FORM [message #439894] |
Tue, 19 January 2010 23:29  |
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,,,
|
|
|
|
Re: ERROR IN SENDING EMAILS FROM A FORM [message #445443 is a reply to message #440424] |
Mon, 01 March 2010 23:28  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS 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
|
|
|