[Orclib-users] Direct Path loading

[Kourosh A. <kou...@gm...>]

Hi,

I am using OCILIB direct path loading.  You can refer to the example 
provided in the documentation.
I want to load about 200 data files using OCILIB direct path 
loading.  My code is very similar to the OCILIB example.
The program terminates with an error message that "A null Statement 
handle has been provided" once it gets to the 138th data file.
The first 137 data files load successfully without any errors.

I added a conditional that after 130 data files have been loaded to 
commit the changes (OCI_DirPathFinish (dp)), and also free the direct 
path object (OCI_DirPathFree (dp)) and then re-create the direct path 
handle, set optional direct path loads, etc.
The program successfully loads the first 130 data files.  It then 
loads 7 more data files successfully and on the 8th one (138th) it 
terminates with the same error message that a null handle was passed.

I increased the buffer size, and it did not fix the error.

Any suggestions, comments would be appreciated.

Thank you!