How to fix the Oracle error ORA-26076: cannot set or reset value after direct path structure is allocated?

In this post, you’ll learn more about the Oracle ErrorORA-26076: cannot set or reset value after direct path structure is allocated with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26076: cannot set or reset value after direct path structure is allocated

Reason for the Error ORA-26076: cannot set or reset value after direct path structure is allocated

Client attempted to set or reset the number of rows in a direct path

* structure after it has already been allocated and initialized.

* Attributes used is one of the following:

* – OCI_ATTR_NUM_ROWS: to set # of rows in a direct path column array

* – OCI_ATTR_DIRPATH_DCACHE_SIZE: to set size of a date cache

* (default is 0)

* – OCI_ATTR_DIRPATH_DCACHE_DISABLE: to set whether date cache will be

* disabled on overflow (default is FALSE)

How to fix the Error ORA-26076: cannot set or reset value after direct path structure is allocated ?

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

Set the following attributes before:

* – OCI_ATTR_NUM_ROWS: before calling OCIHandleAlloc for column array

* – OCI_ATTR_DIRPATH_DCACHE_SIZE: before calling OCIDirPathPrepare

* – OCI_ATTR_DIRPATH_DCACHE_DISABLE: before calling OCIDirPathPrepare