How to fix the Oracle error OCI-21579: Input LCR must have at least one old or new column.?

In this post, you’ll learn more about the Oracle ErrorOCI-21579: Input LCR must have at least one old or new column. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-21579: Input LCR must have at least one old or new column.

Reason for the Error OCI-21579: Input LCR must have at least one old or new column.

An attempt was made to call OCIXStreamInChunkSend with an LCR that had empty column lists.

How to fix the Error OCI-21579: Input LCR must have at least one old or new column. ?

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

Use OCILCRRowColumnInfoSet to add one or more columns to the input LCR before calling OCIXStreamInChunkSend.