CLOB Length as 4000

From: Sundar <rsundararajan_at_gmail.com>
Date: 21 Jun 2006 13:57:32 -0700
Message-ID: <1150923452.071075.217610@y41g2000cwy.googlegroups.com>

Hi,

I have a table in our source system which has defined the CLOB length as 4000. This length is available in the field DATA_LENGTH in ALL_TAB_COLUMNS. But when I search the table to get the max length for the CLOB field using the function DBMS_LOB.GETLENGTH(col1), I got a number around 23000.

So it look lilkes the length definition does not matter for CLOB and it doesnt look like restricting the users from entering data more than 4000.

The reason I am looking at the length is I am planning to convert the CLOB field to VARCHAR without losing anydata from the source.

Can anyone confirm what it means when the table has CLOB (4000)

Would really appreciate your help!!

Thanks in advance,
Sundar. Received on Wed Jun 21 2006 - 15:57:32 CDT