sending email from oracle procedure

Every this works fine. My question is when I am sending email I am getting the email address for sub center

get_email_rec.subcenter_email
This helps me to send email to sub centers pertaining to donors who are donating in that particular donor center. But I want to add my email also there

   url :=
     utl_url.ESCAPE
     (v_server_c || '?' || v_conn_str_c ||
       '&desformat=PDF&ENVID=' || v_report_db_c ||
       '&subject="WB Donors Eligible For Conversion"' ||
       '&destype=mail' ||
       '&FROM=someemail@mail.com&desname=' ||get_email_rec.subcenter_email||
       '&report='||v_letter||'&p_site_id='||get_rep_param_rec.site_id);

like abc@gmail.com. How can I add that after get_email_rec.subcenter_email

[attachment deleted by Zone Advisor at the request of asker]
LVL 6
anumosesAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
>>> This works. But not the parameter

I don't know what you mean by that

also, if you're doing to append addresses, your first address probably needs a delimiter too


 ||',abc@gmail,xyz@gmail.com' ||
0
 
sdstuberCommented:
you could try simply appending it

 '&FROM=someemail@mail.com&desname=' ||get_email_rec.subcenter_email||'abc@gmail' ||

however, the web service you are using might not support it.
if that doesn't work, you'll need to contact the service host to determine what your options are.  You're not using an oracle feature, so it's not really something you can control from the oracle side.  You can only use the api provided.



If you want more control of sending email, you may have to do it yourself.
Fortunately, it's fairly easy to do so.

http://www.experts-exchange.com/Database/Oracle/A_7749-How-to-send-email-attachments-with-Oracle.html
0
 
anumosesAuthor Commented:
As you mentioned

you could try simply appending it

 '&FROM=someemail@mail.com&desname=' ||get_email_rec.subcenter_email||'abc@gmail' ||

does not work. Have to check with service host.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
sdstuberCommented:
I also wonder if it even makes sense to try what you have described.

By adding your address to the FROM line, you are trying to say the message is from two different addresses.

That doesn't make sense.  
You can send TO multiple addresses, but the message is only FROM one source

If you were sending TO multiple addresses, then maybe adding white space or a delimiter between each


||'  abc@gmail' ||

or

||',abc@gmail' ||
0
 
anumosesAuthor Commented:
&FROM=someemail@mail.com&desname=' ||'abc@gmail,xyz@gmail.com' ||

This works. But not the parameter
0
 
anumosesAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.