BLOB parameters in procedure

[Nemezida22]

Hi,

I am using:
DOA 4.0.7.1
OCI: version 8.0
Oracle Database 9i

I want to transfer BLOB parameter to procedure, but it's hard to use temporary BLOB locator (OCI: version 8.0), for example:
// 'ms' is a stream containing my BLOB data
LOB := TLOBLocator.CreateTemporary(Oq.Session, otBLOB, true);
LOB.CopyFrom(ms,ms.size);
with OQ do begin
SetComplexVariable('sDoc',LOB);
SetVariable('CrupName',AppInfo.CrupName);
SetVariable('id_App', AppInfo.id_App);
SetVariable('id_Work',AppInfo.id_Work);
SetVariable('Id_Info',F.Id_Info);
Execute;
Doc.sNameDoc:=GetVariable('a0607');
Doc.ce:=TCodeError(GetVariable('Res'));
Session.Commit;
end;

D' U know another way to transfer it?

 

[Marco Kalter]

No, this requires an Oracle Client version 8.1 or later.