Largest data type size is 4000 characters

[evergrean100]

I have a data types in my Oracle 9i with VARCHAR2(4000).

I cant use anything larger like CLOB in our database.

Can someone advise why we cant create a data type larger than VARCHAR2(4000)?

 

[SantaMufasa]

Evergrean,

Can you please post both your SQL syntax for your CREATE statement for the table containing the CLOB along with the error message that you are receiving?

There is nothing that I am aware of that should be preventing you from creating a table with a CLOB column. (And yes, VARCHAR2(4000) is the largest column you can create that is not a CLOB.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]