Devart Forums

Posted: **Thu 29 Apr 2010 06:56**

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..

Posted: **Thu 29 Apr 2010 14:21**

Hello

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

Posted: **Mon 03 May 2010 01:15**

FreeTemporary method not found..

ODAC does provide the FreeTemporary method?

Posted: **Wed 05 May 2010 15:14**

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;

Devart Forums

CreateTemporary using.. free??

CreateTemporary using.. free??

ODAC does provide the FreeTemporary metohd?