I want to the varchar2 max size in oracle8.1.7.4.0 for solaris.

[oracle10]

hi,

I have a table in coracle8.1.7.4.0 for solaris, there is a column of varchar2. firstly, I set its size 4000, then I want to extend to 8000, but there is a oracle error ora-00910 which said that specified length too long for the datatype. I looked up the docs, and it said the max size can be up to 32767. now I confused of it and don't know what i can do to extend the column size. You advice will be appreciate.

-GAO

[ggnanaraj]

4000 is the max for varchar2.

http://technet.oracle.com/docs/produ...elem.htm#45443

HTH.

[chrisrlong]

A VARCHAR2 *variable* can be 32767, but a column can only be 4000. But be careful, because Oracle was sloppy when they changed from 2000 to 4000. DBMS_SQL.Varchar2_Table is still defined at 2000, for example, so it won't work for larger columns. So much for consistency, eh?

- Chris