How to fix the Oracle error ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement?

In this post, you’ll learn more about the Oracle ErrorORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

Reason for the Error ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

An attempt was made to bind data more than 4000 bytes of data to both LOB and LONG columns in the same insert or update statement. You can bind more than 4000 bytes of data to either a LONG column or one or more LOB columns but not both.

How to fix the Error ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement ?

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

Bind more than 4000 bytes of data to either the LONG column or one or more LOB columns but not both.