Skip to Main Content
Forums

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!

Data length error while inserting

fameApr 6 2016 — edited Apr 6 2016

Hi all,

     This my table structure,

        Create table t_cust(cust_id varchar2(10),

                            national_id VARCHAR2(25));

I am inserting below record, but it throws error. I have checked national length is only 17 but still i am getting error.

insert into t_cust values('001000','26104-بطاقهشخصية');

Error:

ORA-12899: value too large for column "t_cust"."NATIONAL_ID" (actual: 26, maximum: 25)

ORA-06512: at line 1

Thanks,

Fame
This post has been answered by Sergei Krasnoslobodtsev on Apr 6 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2016
Added on Apr 6 2016
5 comments
740 views