Hi,
Just upgraded to 18.1 trying the E-Mail template feauture.
The normal apex_mail.send procedure works and I receive the E-Mail:
BEGIN
apex_mail.send(p_to => 'XXXXXXXXXXXXXXX'/*l_to_addr*/,
p_from => 'XXXXXXXXXXXXXXXXX'/*l_from_addr*/,
p_subj => 'test',
p_body => 'test1234');
apex_mail.push_queue;
END;
I created a E-mail template in APEX (Order confirmation Example) but the apex_mail.send and the apex_mail.prepare_template throws and ORA-01403 error:
Bug?
begin
apex_mail.send (
p_to => 'steven.king@example.com',
p_template_static_id => 'ORDER_CONFIRMATION',
p_placeholders => q'~
{
"CUSTOMER_NAME": "Steven King",
"ORDER_NUMBER": 1234,
"ORDER_DATE": "02-Feb-2018",
"SHIP_TO": "Steven King",
"SHIPPING_ADDRESS_LINE_1": "2004 Charade Rd",
"SHIPPING_ADDRESS_LINE_2": "Seattle, Washinton",
"ITEMS_ORDERED": 3,
"ORDER_TOTAL": "$ 1,200.99",
"ORDER_URL": "http://domain/apex/f?p=&APP_ID"
}~' );
apex_mail.push_queue;
end;
Error report -
ORA-01403: no data found
ORA-06512: at "APEX_180100.WWV_FLOW_MAIL", line 1018
ORA-06512: at "APEX_180100.WWV_FLOW_MAIL", line 818
ORA-06512: at "APEX_180100.WWV_FLOW_MAIL", line 854
ORA-06512: at "APEX_180100.WWV_FLOW_MAIL_API", line 88
ORA-06512: at line 2
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.