CLOB data type

[BALAJI_JAY]

I am able to write CLOB data type on to the Oracle database. I would like to know how to read CLOB data type from database because the text buffer size in coldfusion is restricted to 64000 bytes. Please help me with your ideas.
Thanks in advance.

[Newsgroup_User]

BALAJI_JAY wrote:
> I am able to write CLOB data type on to the Oracle database. I would like to
> know how to read CLOB data type from database because the text buffer size in
> coldfusion is restricted to 64000 bytes.

In the CF administrator enable the "CLOB" checkbox.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[BALAJI_JAY]

Can you tell me where I can locate the "CLOB" checkbox in the CFADMIN window?
Thank you, Balaji

[paross1]

Select Show Advanced Settings for your datasource, and you should see select boxes that look something like this:

CLOB -- Enable long text retrieval (CLOB).
BLOB -- Enable binary large object retrieval (BLOB).
Long Text Buffer (chr) 64000
Blob Buffer(bytes) 64000

Select CLOB and/or BLOB, whatever is applicable.

Phil

[BALAJI_JAY]

Thank you for your kind help. I would really appreciate your help.
Regards,
Balaji