Invalid BLOB handle when setting TLobLocator.Buffering to True

[ldsandon]

This code:

Lob := TLOBLocator.Create(ssMain, otBLOB);
try
  Lob.Buffering := True;

raises an exception "TLobLocator: Invalid handle".

Delphi 7 (build 8.1), Oracle 9.2.0.5, DOA 4.0.6.2.

 

[ldsandon]

Of course until I execute the query the LOB is not valid. Could the class handle it or not?

 

[Marco Kalter]

The buffering property if only valid for temporary LOB's (created with TLOBLocator.CreateTemporary). We'll raise an explicit exception instead of relying on the (vague) Oracle exception.