cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01401: inserted value too large for column

former_member529475
Active Contributor
0 Kudos

Hi,

I am facing an issue in the receiver JDBC Channel.

I am not able to post the records into the Table. and it is throwing the error.

ORA-01401: inserted value too large for column

While exeucted the insert statement manually, I am able to post.

From PI, I am not able to post the records. I tried with single charater also. But no use.

Any idea on this.

Regards,

Vasu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Cross check the data types and field lenghts with the types defined in dB table.

There might be type mismatch and it might be expecting data in a particular format for few fields.

Answers (3)

Answers (3)

former_member241146
Active Participant
0 Kudos

Hi Vasu.

One of this field values are with lenght bigger than lenght determined in the DB Column for this DB Table.

You have to confirm these lenghts and values.

PS.: Sometimes the message is with blank spaces in a field and you can't see in a Message Monitor/SXMB_MONI (you can see the real value trought Payload->Right Button->Source Code). You have to use a TRIM Standard Function to supress this spaces.

Best Regards.

Bruno.

GabrielSagaya
Active Contributor
0 Kudos

It means that one of the field values which you are inserting are bigger than the column size in the oracle table.

Please check all the input values with the table column size.

Former Member
0 Kudos

Could you provide us the payload ?

Regards,

TK