请教各位高手 delphi 图像 存到 oracle 里怎么最方便？

Question

delphi 图像 存到 oracle 里怎么最方便？用 bde Tquery  , SQL 可以达到 INSERT, UPDATE  等操作吗？

Answer 1

FileStream:=TFileStream.Create(opendialog1.FileName,fmOpenRead);
   temptable.Edit;
   BlobStream:=TadoBlobStream.Create(TMemoField(temptable.FieldByName('img_attach')),bmreadWrite);
   BlobStream.Seek(0,soFromBeginning);
   BlobStream.Truncate;
   BlobStream.CopyFrom(FileStream,FileStream.size);
   filestream.Free;
   BlobStream.free;
   temptable.Post;