Forum .LRN Q&A: acs-mail-lite uses text not clobs ...
mailbox with watchdog error reports ...
If a package, say forums, sticks something longer than 4K bytes into a
notification everything more or less barfs due to the use of text
rather than CLOB fields. It looks like it causes sweeping to fail and
leads to repetitive failure because the offender neither gets sent nor
I'm digging into this in a few minutes but ... is there any reason not
to use CLOBs here? I realize they're a bit less efficient but isn't it
best to send the full text of forum posts and the like no matter what?
I think you have to use CLOBs for another reason, too. SQLPlus still can't handle string literals longer than 2499 characters, and I think the Oracle ODBC driver has this problem as well. This means that if you have to create a script that does literal inserts/updates of some text and your text is longer than 2499 characters then SQLPlus won't do the insert. Also, if you edit a field in Access (ugh, I know, but it's sort of the best client on Windows to browse the database contents) and it had content of more than 2499 characters it gets truncated.
The disadvantage to clobs is that you can't say
select x from y where x like '%somevalue%';
(If I'm wrong about that I'd love to hear about it).
I see the use of clob in notifications and acs-mail-lite. Am I looking in the
I'll look into chopping off the subject before trying to insert it ...
Sorry for that!