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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,671 views