Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00910: specified length too long for its datatype

Harsh_vJul 20 2012 — edited Jul 24 2012
Dear 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2012
Added on Jul 20 2012
36 comments
19,883 views