You are here: Home // Oracle 11g // ORA-26076: cannot set or reset value after direct path structure is allocated

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)
See the solution below.

Error 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

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: naprawa laptopow katowice Katalog stron - Nieruchomoƛci expekt bonus BHP kabiny prysznicowe