Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex Mail BCC size limit

jfosteroracleMay 15 2009 — edited May 15 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2009
Added on May 15 2009
1 comment
644 views