TOracleDirectPathLoader, 64K limit on BLOB-column?

[Lars J]

It seems that OracleDirectPathLoader has a limit of 64K on the data in a single column, and if the size-parameter in the TDirectPathColumn.SetData is larger than 64K, there will be an overflow on the size-parameter and only a smaller portion of the data is loaded. Is this correct?

I am using DOA 3.4.6

Regards
Lars J

 

[Marco Kalter]

You will have to set the TOracleDirectPathLoader.BufferSize property to a value that can store the maximum record size.

 

[Lars J]

I do not think that will fix it. It may be a limitation in OCI.

Oracle supports something they call "Direct Path Loading in Pieces" to support large objects, and it seems that TOracleDirectPathLoader does not support this.

If I am really wrong about this, please excuse my lack of understanding.

Regards
Lars J

 

[Marco Kalter]

Piecewise loading may be a feature, but I don't think it is a requirement. I will check it out though.