SQL & PL/SQL

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!

NVARCHAR2 DataType issue

640163Apr 21 2009 — edited Apr 21 2009

Hi All:

I would like to need some clarification about the data type that store maximum 4000 characters. I just checked in the sites , they are referring NVARCHAR2 data type stores 4000 chrs. But i tried in the Oracle 10G Express edition, it accepts only 2000 characters. Please find the following error for your kind reference.

SQL> create table t (name1 NVARCHAR2(4000));
create table t (name1 NVARCHAR2(4000))
*
ERROR at line 1:
ORA-00910: specified length too long for its datatype

is it any problem in the syntax. Please let me know ASAP.
Thanks in advancve.

Thanks,
Prathap

Edited by: user637160 on Apr 20, 2009 11:10 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2009

Added on Apr 21 2009

11 comments

2,144 views