Storing Images to an Oracle Database


2007-08-15 04:48:26 AM
delphi229
Does anyone have an example of storing a jpeg or other binary file to
an Oracle Table? I find that using the BLOB file type I cannot even
do a select statement; ADO does not recognize the data type. I am
able to get this going in SQL Server and MySql with code like this:
Dataset1.Edit;
DataSet1.FieldByName('IMAGEBLOB') as TBlobField).BlobType :=
ftBlob;
TBlobField(DataSet1.FieldByName('IMAGEBLOB')).LoadFromFile(PathVar +
FileNameField.Text);
DataSet1.Post;