Hi all.
I'm after general information on storing/ retrieving a CLOB, then manupulate the data before some sort of output.
The reason I'm asking: I've got some emails set up where HTML text is stored (in the process) in VARCHAR2 variables. I pull page item data and fill some markers in the HTML and send the email. One of these emails has a large HTML source that I store in 3 x Varchar2(4000) variables and I concatenate these into one source to send. I know there is a limit quickly approaching with this method.
Is it feasible to be storing HTLM info (or MS Dopcument, or PDF document) in a CLOB or BLOB, retrieving the "template", filling the markers and then displaying, or emailing , or attaching om an email?
Any direction or info on this is appreciated.
NT