The cci_col_get function gets an attribute value of collection type. If the name of the class is C, and the domain of set_attr is set (multiset, sequence), the query looks like as follows:
SELECT a FROM C, TABLE(set_attr) AS t(a) WHERE C = oid;
That is, the number of members becomes the number of records.
intcci_col_get (int conn_handle, char *oid_str, char *col_attr, int *col_size, int *col_type, T_CCI_ERROR *err_buf)