How to fix the Oracle error ORA-26093: input data column size (number) exceeds the maximum input size (number)?

In this post, you’ll learn more about the Oracle ErrorORA-26093: input data column size (number) exceeds the maximum input size (number) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26093: input data column size (number) exceeds the maximum input size (number)

Reason for the Error ORA-26093: input data column size (number) exceeds the maximum input size (number)

The user attempted to specify a column size (%d) that exceeded

* the maximum allowable input size (%d).”

How to fix the Error ORA-26093: input data column size (number) exceeds the maximum input size (number) ?

You can fix this error in Oracle by following the below steps

Make sure the input column metadata matches the column definition.