asked on

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]

Sean Stuber

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.

https://www.experts-exchange.com/Database/Oracle/A_7749-How-to-send-email-attachments-with-Oracle.html

anumoses

ASKER

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.

Sean Stuber

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' ||

anumoses

ASKER

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

This works. But not the parameter

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anumoses

ASKER

thanks