TOracleDirectPathLoader & ORA-24329

[Tony Pavlov]

Hello!

I have a problem with TOracleDirectPathLoader. When calling Prepare I receive ORA-24329 error. I doesn't matter if I set table owner in tablename or not - result is the same.

I also faced with the problem "exception: """ while calling Prepare. With net8 exception contains no text, but under 10-th version the exception text contains ORA-01009 error. I solved it using "UseSingleEnvironment := False;".

My DOA version is 4.0.5

Please, help!

 

[Marco Kalter]

Are both problems fixed with "UseSingleEnvironment := False"? This is the default in 4.0.6.

 

[Tony Pavlov]

Only the second. I fixed the first one (ORA-24329), using oracle 10 client instead of net8.

Not on this topic, but one question:

I'm not sure, but it seems that SetData do not actually copy data into the buffer set by BufferSize property until I call Load method? Please, if I'm not mistaking include this into the documentation, it seems to be a quite common problem.