Skip to main content
B
BALAJI_JAY
Participating Frequently
July 8, 2008
Question

CLOB data type

  • July 8, 2008
  • 1 reply
  • 1202 views
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.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
July 9, 2008
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
B
BALAJI_JAYAuthor
Participating Frequently
July 9, 2008
Can you tell me where I can locate the "CLOB" checkbox in the CFADMIN window?
Thank you, Balaji
P
paross1
Participating Frequently
July 9, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices