Folks,
Strange problem. When I try to send email using the following (took this out of the procedure I used )
BEGIN
FOR C1 IN (
SELECT WORKSPACE_ID
FROM APEX_APPLICATIONS
WHERE APPLICATION_ID = 352 )
LOOP
APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => C1.WORKSPACE_ID);
END LOOP;
APEX_MAIL.SEND (
P_TO => 'xxxxx@gmail.com',
P_FROM => 'yyyyy@gmail.com',
P_APPLICATION_ID => 352,
P_TEMPLATE_STATIC_ID => 'TRANSPORTER',
P_PLACEHOLDERS => '{' ||
' "TRANSPORTER":' || APEX_JSON.STRINGIFY( 'V_TNAME') ||
' "DOG":' || APEX_JSON.STRINGIFY( 'V_DOG') ||
' "OWNER":' || APEX_JSON.STRINGIFY( 'V_SNAME') ||
' "ADDRESS":' || APEX_JSON.STRINGIFY( 'V_ADDR') ||
' "CITY":' || APEX_JSON.STRINGIFY( 'V_CITY') ||
' "STATE":' || APEX_JSON.STRINGIFY( 'V_STATE') ||
' "PHONE":' || APEX_JSON.STRINGIFY( 'V_PHONE') ||
' "TIME":' || APEX_JSON.STRINGIFY( 'V_TIME') ||
' "INSTRUCTIONS":' || APEX_JSON.STRINGIFY( 'V_INST') ||
'}' );
APEX_MAIL.PUSH_QUEUE;
END;
I get the following error:
Error report -
ORA-20987: Error at line 1, col 33: Expected "}", seeing "<varchar2>"
ORA-06512: at "APEX_210100.WWV_FLOW_JSON", line 1320
ORA-06512: at "APEX_210100.WWV_FLOW_JSON", line 560
ORA-06512: at "APEX_210100.WWV_FLOW_JSON", line 1268
ORA-06512: at "APEX_210100.WWV_FLOW_JSON", line 1302
ORA-06512: at "APEX_210100.WWV_FLOW_JSON", line 1379
ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 979
ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 759
ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 795
ORA-06512: at "APEX_210100.WWV_FLOW_MAIL_API", line 88
ORA-06512: at line 11
If I limit the template parameters to one item it works fine, but as soon as I add the second item it fails.