How to use Clob (or any other alternative)
391382Jun 7 2006 — edited Jun 8 2006Hi All,
I have develop a "nice" pl/sql procedure that can send emails with/without file attachments, but i'm experience a limitation with the message body.
The message body presently is using a variable of type varchar2 that has a max limit of 32 Kb, i was thinking about changing this into a CLOB variable or any other type of one.
But every example that i see using a CLOB is a big mess... creating temporary data.. opening clob apening somehting, and i have yet to see how to READ from a clob into something else AAaaaaaaa
The type long appears much better but oracle is dropping this (why !!!)
Can anyone please give me a good example how i can create and append text into a pl/sql variable that suports more than 32 Kb
Miguel Angelo