Apex Mail BCC size limit
I use the Apex mail built-in code to send out an e-mail to a users group. The e-mail addresses are in a table, and I pull from that table and append them to create a blind copy list of all the e-mail addresses. I ran into a size limitation because the list of e-mails is long enough that the bcc string is now over 2000 characters. I tried changing my local variable in my procedure to 4000 characters, but evidently there is a restriction of 2000 characters within Apex code. This is the error i get:
ORA-12899: value too large for column "FLOWS_030100"."WWV_FLOW_MAIL_QUEUE"."MAIL_BCC" (actual: 2098, maximum: 2000)
Has anyone run into this problem and have a different was of sending out message to a group?
I can paste the actual code i am using if needed.
THanks,
John