Oracle Error Codes

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 Solve :

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