ORA-00910: specified length too long for its datatype
Harsh_vJul 20 2012 — edited Jul 24 2012Dear sir,
In my production required 8000 bytes string. but varchar2 data type not support 8000 bytes string length.
Any alternate in oracle where we can take 8000 bytes string support.
Oracle version = 10G
OS = Red hat 5.5
SQL> create table smsc_martine_new (sms_scope varchar2(8000));
create table smsc_martine_new (sms_scope varchar2(8000))
*
ERROR at line 1:
ORA-00910: specified length too long for its datatype
please help sir
thanks in advance