ORA-01401 Inserted value too long

[roedelfroe]

Hi everybody,

following problem:

How can i figure out, WHICH column causes the problem "inserted value too long". Any stupid Access Database will give you the information, which column causes this error, but not Oracle!

Is there a tool/procedure or whatever available, which can do that in Oracle too?

Thx in advance

Roland

 

[hoinz]

Hi,

first of all, which tool are you using for inserting?
If it's SQLplus, it will tell you. There will be a ' right under the offending column.
Hope this helps

 

[hoinz]

Sorry, a * , not a '

 

[roedelfroe]

I'm using SQLplus. But SQLplus won't tell you, which column causes the problem. SQLplus will highlight the insert command, which is really not helpful.

1 INSERT INTO doku_tb
2 (doku_id, doku_name, reason, cdate)
3 VALUES
4 (doku_seq.nextval,
5 'Confirming Trade 0765738367',
6 'Confirming Trade / New Customer',
7 sysdate);

INSERT INTO doku_tb

*

ERROR at line 1:

ORA-01401: inserted value too large for column


So, there is absolutely no information, which column causes the problem. SQLplus won't tell you, neither does SQLNavigator.

Greetings

Roland

 

[hoinz]

Hi,

I just tried myself, and SQLplus told me, as I wrote above.
So it seems that different settings are to be blamed.
But I don't know which.

 

[hoinz]

Hi,
another idea:
Write all your values in one long line; the position of the * might give some hints then.
hth

 

[SantaMufasa]

Roland,

No question about it...Oracle has some "doofus" weaknesses in its error reporting. Having acknowledged that, could you please post a describe of your "DOKU_TB"? Perhaps that will shed some light on this specific problem.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:33 (20Aug04) UTC (aka "GMT" and "Zulu"), 10:33 (20Aug04) Mountain Time)