ORA-26076: cannot set or reset value after direct path structure is allocated
Cause : 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)
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
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
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.