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

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

Oracle Error Description

ORA-38907: DML error logging is not supported for FILE column “string”

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

A DML Error Logging operation was attempted on a table which has a BFILE column and the Error Logging table referred to the specified column.

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

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

Either don’t 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 BFILE column types.