How to Update BOLB Fields (Oracle 10G )
Posted: 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?
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?