Oracle Solution for Error ora-26076

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

What triggered the Error:

ient attempted to set or reset the number of rows in a direct path *p>** structure after it has already been allocated and initialized. *p>** Attributes used is one of the following. *p>** - OCI_ATTR_NUM_ROWS: to set # of rows in a direct path column arra. *p>** - OCI_ATTR_DIRPATH_DCACHE_SIZE: to set size of a date cach. *p>** (default is 0. *p>** - OCI_ATTR_DIRPATH_DCACHE_DISABLE: to set whether date cache will b. *p>** disabled on overflow (default is FALSE.

What should we do to fix it:

t the following attributes before: *p>** - OCI_ATTR_NUM_ROWS: before calling OCIHandleAlloc for column arra. *p>** - OCI_ATTR_DIRPATH_DCACHE_SIZE: before calling OCIDirPathPrepar. *p>** - OCI_ATTR_DIRPATH_DCACHE_DISABLE: before calling OCIDirPathPrepar.