How to fix the Oracle error ORA-26679: operation not allowed on LOB or LONG columns in LCR?

In this post, you’ll learn more about the Oracle ErrorORA-26679: operation not allowed on LOB or LONG columns in LCR with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26679: operation not allowed on LOB or LONG columns in LCR

Reason for the Error ORA-26679: operation not allowed on LOB or LONG columns in LCR

Certain operations on LOB/LONG columns of the LCR through rule-based transformations, DML handlers, or error handlers were not allowed.

How to fix the Error ORA-26679: operation not allowed on LOB or LONG columns in LCR ?

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

Do not perform restricted operations on LOB or LONG columns in LCRs. See the documentation for operations that are restricted on LOB/LONG columns in LCRs.