Forum .LRN Q&A: Response to bug in bulk-mail and notifications with notification > 4k in size

The PL/SQL type is purposely set to varchar instead of clob. This is a trick that
allows us to use clobs (> 4K) but treat them as varchars. We discovered this
through a coding mistake.

Our tests, however, show that we can insert notifications far larger than 4K, so
I'm not sure where your bug is coming from. Can you give us the rundown of
your platform?