How to Update BOLB Fields (Oracle 10G )

Bingowang · Post by **Bingowang** » Thu 04 Sep 2008 10:28

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?

Plash · Post by **Plash** » Fri 05 Sep 2008 08:21

Please specify the error that Oracle returns.

Bingowang · Post by **Bingowang** » Fri 05 Sep 2008 08:51

I resolve it
ODAC 6 have not the problem
but ODAC 5 have