Home » SQL & PL/SQL » SQL & PL/SQL » Inserted Value too large for column
Inserted Value too large for column [message #19770] Mon, 08 April 2002 12:51 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I am getting this error message when I tried to insert into a table

ORA-01401: inserted value too large for column.

The source table is having the column as "0...............................". The total length of this value is 61 and on the data base, the field is defined as varchar2(255). The target table is also defined the same way as source table. Why it is giving this error eventhough the length of the value is not big enough to the defined column length?

Thanks,

Uma
Re: Inserted Value too large for column [message #19771 is a reply to message #19770] Mon, 08 April 2002 13:02 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
1.) Make sure the order of the columns corresponds correctly between source and target.

2.) create table temp_1 as (your query goes here);
Now describe TEMP_1 to confirm the column widths.

3.) http://asktom.oracle.com/pls/ask/f?p=4950:8:670307::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1205650687947,

4.) If you think that you could have trailing spaces on vahchar columns - chech that.
select col1||'<<', length(col1) from my_tab where rtrim(col1) != col1;
Previous Topic: Is there a way to copy a stored procedure to another schema on a different server
Next Topic: movie
Goto Forum:
  


Current Time: Mon Mar 18 21:33:15 CDT 2024