|Oracle Call Interface Programmer's Guide
Release 2 (9.2)
Part Number A96584-01
OCI Datatype Mapping and Manipulation Functions, 134 of 134
Returns the size of the given table, not including deleted elements.
The OCI environment handle initialized in object mode.
The OCI error handle. If there is an error, it is recorded in
err and this function returns OCI_ERROR. Obtain diagnostic information by calling
Nested table whose number of elements is returned.
Current number of elements in the nested table. The count does not include deleted elements.
The count will be decremented upon deleting elements from the nested table. So this count does not include any holes created by deleting elements. To get the count not including the deleted elements, use
OCITableSize(...); // assume 'size' returned is equal to 5 OCITableDelete(...); // delete one element OCITableSize(...); // 'size' returned is equal to 4
To get the count plus the count of deleted elements use
OCICollSize(). Continuing the previous example:
This function returns an error if an error occurs during the loading of the nested table into the object cache, or if any of the input parameters is null.