This content has been marked as final. Show 10 replies
Thanks a lot for your immediate reply.
we are using Oracle 9i.
I'm able to find which column it is. But some times we dont know data behaviour some time if may get some asci characters or some how if we can get big string its a problem, i want to handle this in exception part. Thats my concern.
Once again thanks a lot.
I am also facing the same problem as you stated earlier.Would you please help me in solving the below problem .What exact solution you used to solve the problem.
Problem as stated:
Is there any way to find out which column is causing inserted value too large for column the problem? I'm trying to insert the data into a table by using cursor into a table in a procedure. My table is having 80 columns.
i saw ur reply in this forum.. i am facing a problem in this regard, plz help me
actually i am passing 10 parameters in a procedure. these values are GOING TO insert in one table. when i get any errorr i just want to know in which column error is araise... i know to write exceptions for any error, but i dont know how to find this error in that particular column (reside)..
As someone said, above: What would that help?
Allow me to demonstrate the problem.
So, which column was it?
9i:SQL> create table t (x varchar(10), y varchar2(10)); Tabel er oprettet. SQL> SQL> insert into t select object_name, object_type from all_objects; insert into t select object_name, object_type from all_objects * FEJL i linie 1: ORA-01401: value too large
(*Looks like SQL*Plus knows, Perhaps because I faked it running in 10g, what will it look like in 9i, anyone?*)
Where as in 10g:
10g:SQL> create table t (x varchar(10), y varchar2(10)); Tabel er oprettet. SQL> SQL> insert into t select object_name, object_type from all_objects; insert into t select object_name, object_type from all_objects * FEJL i linie 1: ORA-12899: value too large for column "SCOTT"."T"."X" (actual: 16, maximum: 10)