I have a program. It runs well on oracle 9i. It retrieves all 100000 records into memory for some reason. I use OCIDefineArrayStructre and OCIStmtFetch2. Now I have to run this program on oracle 8i, although I hate it. I change OCIStmtFetch2 to OCIStmtFetch since oracle 8i has no OCIStmtFetch2. The problem is the records in memory after 64K rows were empty after I executed OCIStmtFetch(100000). It looked like it only fetched 64K rows.Although I used OCIAttrGet to check OCI_ATTR_ROW_COUNT was 100000.
Does anyone know how to solve this problem? Is there a maximum number of fetched rows each time?
Thank you very much!