[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

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]
0
anumoses
Asked:
anumoses
  • 3
  • 3
1 Solution
 
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
 
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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

This works. But not the parameter
0
 
sdstuberCommented:
>>> 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
 
anumosesAuthor Commented:
thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now