Greetings,
We're working on a system that is going to be sending email to users as part of a business workflow. As we all know HTML email sizes can become very bloated, especially when Microsoft Outlook comes into the mix.
We've created an email template that will work for what we need, and I'm able to split it down into the base HTML Template, Header, Body & Footer. The templates saves into the database fine, but when I go to test it I get the following error.
Error report -
ORA-22828: input pattern or replacement parameters exceed 32K size limit
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL", line 778
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL", line 815
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL", line 1202
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL", line 1071
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL", line 1109
ORA-06512: at "APEX_220200.WWV_FLOW_MAIL_API", line 90
ORA-06512: at line 55
ORA-06512: at line 55
22828. 00000 - "input pattern or replacement parameters exceed 32K size limit"
*Cause: Value provided for the pattern or replacement string in the form of
VARCHAR2 or CLOB for LOB SQL functions exceeded the 32K size limit.
*Action: Use a shorter pattern or process a long pattern string in multiple
passes.
I'm confused that I'm allowed to save a template over 32K, but not allowed to SEND it. I've even gone through and minified all the parts.
Is this a bug, a limitation of something downstream? If so, why does APEX allow you to save a template that's over 32k?