I know that CLOB is basically a large amount of text,right?
How big are you talking?
I don't know if there's a download limit on, for example, a
LoadVars request... I couldn't find any reference to one.
But if you can just output the value of the text serverside
then you can catch it in flash via a LoadVars onData handler in
response to a LoadVars load or sendAndLoad. I'd imagine its
probably better to catch the raw text straight off using onData
like that, sent as the only content in the http response.
If its too big you might want to split it up and send chunks
of it separately. I've never tried this with huge amounts of text
before... but if the browser could handle loading it in one http
response, then flash should be able to as well I think.