BDE access Oracle Blob ERROR!


2003-10-08 10:58:35 AM
off-topic0
My environment is Delphi 7 and Oracle 8i. When I used BDE access blob
field, a error occurred.
The error message is like: "General SQL error! ORA-22990:LOB Locator can
not extend transaction handling..."
I tryed to use TTable, TQuery to access the field, but no sucess.
Some of my codes like following:
1:
with Table1 do
begin
Open;
Append;
FieldbyName('id').AsString := '100';
TBlobField(FieldbyName('Data')).LoadFromFile(FileName);
Post;
end;
2:
with Query1 do
begin
Close;
Sql.Clear;
Sql.Add('Insert into MyUser.Table1 Values(:id,:data)');
ParambyName('id').AsString := '200';
ParambyName('data').LoadFromFile(FileName,ftOraBlob);
Prepare;
ExecSql;
end;