After upgrade to Apex 24.1 we are experiencing the following issue:
within a pl/sql block we are using the following code:
…
apex_mail.send (
p_to => v_to,
p_application_id => 999,
p_template_static_id => 'TEMPLATE_NAME',
p_placeholders => '{' ||
' ,"TABULAR_DATA":' || apex_json.stringify( l_tabular_data ) ||
'}' );
…
Within the eMail-Template html body is set to the following:
<!DOCTYPE html>
<html>
<body>
<p>…. </p>
<br />
<p>
#TABULAR_DATA#
</p>
</body>
</html>
Until the upgrade this worked perfectly and there was a table displayed within the sent email.
Now it doesn't work. Instead in the email the html itself is shown.
Example:
<table style="background-color:white;"><tbody><tr><td style="padding:9.0pt;vertical-align:top;"><p><span style="color:#3E3E3E;">Bitte xxx überprüfen. </span></p><p> </p><p><span style="color:#3E3E3E;"><head><style>.my_table {font-family: arial, Helvetica, sans-serif;border-collapse: collapse;width: 100%;}.my_table th {background-color: #ff6666;border: 1px solid #dddddd;text-align: left;padding: 8px;}.my_table td {background-color: #ffe6e6;border: 1px solid #dddddd;text-align: left;padding-left: 8px;}</style></head><table class="my_table"><tr><th>ID</th><th>XXX</th><th>NAME</th><th>TIME</th><th>RRRR</th><th>RC</th><th>TEXT</th></tr><tr><td>15502</td><td>blabla</td><td>check blabla</td><td>31.12.2023 12:56:13</td><td>ERROR</td><td>0</td><td>Fehler! </td></tr></table> </span></p></td></tr></tbody></table>
We have not been able to find a solution yet.
I'd be greatful for any and all advice.
edit 20.09.2024: using #TABULAR_DATA!RAW# did not make a difference. The email still displayed the html string.