How to fix the Oracle error ORA-26889: LOB assembly not supported for PDML parent transaction string, child transaction string.?

In this post, you’ll learn more about the Oracle ErrorORA-26889: LOB assembly not supported for PDML parent transaction string, child transaction string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26889: LOB assembly not supported for PDML parent transaction string, child transaction string.

Reason for the Error ORA-26889: LOB assembly not supported for PDML parent transaction string, child transaction string.

LOB assembly is not supported for PDML transactions.

How to fix the Error ORA-26889: LOB assembly not supported for PDML parent transaction string, child transaction string. ?

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

Disable LOB assembly, or filter out the PDML transaction.