ORA-24817: Unable to allocate the given chunk for current lob operation

[sentimex]

Hi,

using Delphi XE + DOA 4.1.2.2:

WS := TWideStringList.Create;
WS.LoadFromFile(filenames[I]);

LOB := TLOBLocator.CreateTemporary(OracleSession1, otCLOB, True);

// When the file size is above ~ 16MB this fails on : ORA-24817: Unable to allocate the given chunk for current lob operation
LOB.AsWideString := WS.Text;

Any suggestions on how to do this? Please help.

Thanks.

 

[Marco Kalter]

You can use the LOB.Write function to write the large text in smaller parts in a loop.

 

[sentimex]

Could you give simple example please?

 

[sentimex]

And this brings me to another question what would be the difference between:

LOB.AsWideString := WS.Text;

and

LOB.LoadFromFile(..);

?

 

[Marco Kalter]

The first passes the entire string to the LOB in one call.

The second uses the Delphi TStream.CopyFrom function to load the data from the file. Looking at the TStream.CopyFrom implementation this uses a maximum chuck size of 61440 bytes ($F000).