CreateTemporary using.. free??

[parksj]

b := TOraLob.Create(AuroraSession.OCISvcCtx);
b.CreateTemporary(ltBLob); <-- tablespace temp add
b.LoadFromFile('C:\TEST.TXT');
b.WriteLob;
ParamByName('P_STREAM').AsOraBlob := b;
Execute;
b.FreeLob;

tablespace temp don,t free!!

how free??

thank you..

[bork]

Hello

After creating temporary LOB by the method CreateTemporary you should call the method FreeTemporary to free the contents of the temporary LOB.

[parksj]

FreeTemporary method not found..

ODAC does provide the FreeTemporary method?

[bork]

Yes, the TOraLob class contains the public "FreeTemporary" method. I can compile and execute the following code:

Code: Select all

var
  b: TOraLob;
begin
  b := TOraLob.Create(AuroraSession.OCISvcCtx);
  b.CreateTemporary(ltBLob);
  b.LoadFromFile('C:\TEST.TXT');
  b.WriteLob;
  b.FreeTemporary;
  b.FreeLob;
end;