How to fix the Oracle error SQL*Loader-00653: XML data set to NULL in column string, row number, table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00653: XML data set to NULL in column string, row number, table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00653: XML data set to NULL in column string, row number, table string

Reason for the Error SQL*Loader-00653: XML data set to NULL in column string, row number, table string

Encountered errors (e.g. parsing errors in LOBFILE) while loading LOBs into an XML column. The row will remain in the table and its XML column will be initialized to null. Loading of other records will continue.

How to fix the Error SQL*Loader-00653: XML data set to NULL in column string, row number, table string ?

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

Correct the data file (see accompanying messages) and reload.