How to fix the Oracle error ORA-38904: DML error logging is not supported for LOB column “string”?

In this post, you’ll learn more about the Oracle ErrorORA-38904: DML error logging is not supported for LOB column “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38904: DML error logging is not supported for LOB column “string”

Reason for the Error ORA-38904: DML error logging is not supported for LOB column “string”

A DML Error Logging operation was attempted on a table which has a CLOB, NCLOB, or BLOB column type, and the error logging table referred to the specified column.

How to fix the Error ORA-38904: DML error logging is not supported for LOB column “string” ?

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

Either do not use DML Error Logging on such table or remove the offending column from the error logging table. The scalar columns can be logged, but not LOB column types.