EXEC SQL Error: ORA-01401: Inserted value too large for column

[Former Member]

Getting this SQL Error: ORA-01401: Inserted value too large for column..on an EXEC SQL Insert statement when writing to an

external Oracle DB from SAP.

On further analysis..it appears that this happens to the fields..when the string length matches the field length.

Example: Plant field is defined as char(4) on the SAP side and it is a Varchar2(4) on the Oracle side.

When a value like '1015' is passed thru a variable in the insert statement then this ORA-01401 error pops up.

No error:

- if the value '1015' is passed directly in the insert statement to the external table (or)

- when a value with 3 chars or less(like the first three chars..101) is passed thru a variable defined as 'Plant(4) type c'.

- when using EXEC sql within SAP

- when reading from the external db table

This was working ok until the Oracle Patch P9147110 was installed recently.

Any suggestions !

[stefan_koehler]

Hello Dvas,

what's the characterset of your external database?

What's the column definition in your external database (byte or character based)?

If you use a characeterset like UTF8 it is possible, that one character needs more than one byte and then you will run into such kind of issues if the definition is too small.

Regards

Stefan