How to fix the Oracle error SQL*Loader-00292: ROWS parameter ignored when an XML, LOB or VARRAY column is loaded?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00292: ROWS parameter ignored when an XML, LOB or VARRAY column is loaded with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00292: ROWS parameter ignored when an XML, LOB or VARRAY column is loaded

Reason for the Error SQL*Loader-00292: ROWS parameter ignored when an XML, LOB or VARRAY column is loaded

Command-line arguments contained a ROWS parameter. Specifying save points using the ROWS parameter is not supported when any table being loaded contains a LOB or a column stored as a LOB. XML and VARRAY columns may be stored as a LOB.

How to fix the Error SQL*Loader-00292: ROWS parameter ignored when an XML, LOB or VARRAY column is loaded ?

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

Remove the ROWS parameter from the command-line arguments.