Page 1 of 1

How to Update BOLB Fields (Oracle 10G )

Posted: Thu 04 Sep 2008 10:28
by Bingowang
When Oracle 8i,It Works

SQL.Add('Update RptDef');
SQL.Add('Set RptBlob = EMPTY_BLOB()');
SQL.Add(' Where BH=:BH');
SQL.Add(' Returning RptBlob Into :RptBlob');
ParamByName('BH').AsString:='1102';
ParamByName('RptBlob').ParamType := ptInput;
ParamByName('RptBlob').AsOraBlob.LoadFromFile(FileName);
ExecSql;

But Oracle10G,return errors
Why?

Posted: Fri 05 Sep 2008 08:21
by Plash
Please specify the error that Oracle returns.

It Works

Posted: Fri 05 Sep 2008 08:51
by Bingowang
I resolve it
ODAC 6 have not the problem
but ODAC 5 have