Re: CLOBs - 4000char limit?

I think I found the answer now :)
If the CLOB gets bigger than 4000 chars Oracle will automatically move it out of the row

• Kev

kev wrote:

> Hi,
>
> I'm playing with CLOBs, well, trying to.
>
> If I create a table with:
>
> create table test1 (myclob1 clob);
>
> ...and then do:
>
> describe test1
>
> ...I get:
>
> Column Name Null? Type
> ------------------------------ -------- ----
> MYCLOB1 CLOB(4000)
>
> ...and if I do:
>
> select * from test1;
>
> ...I get:
>
> ORA-00932: inconsistent datatypes
>
> Both these events were unexpected. Can I change the size of the CLOB?
> (the Oracle doc 'LOB restrictions' doesn't mention any size limit)
> And why the 932 error? (Doing a 'oerr ora 932' doesn't give an
> explanation).
>
> thanks,
>
> - Kev
Received on Wed Mar 15 2000 - 10:52:38 CST