Oracle Error Message
ORA-26076: cannot set or reset value after direct path structure is allocated
Reason for the Error
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)
Solution
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