Using Oracle 8.0.4 (on NT) with DOA 3.4.3 I've create this sequence of code:
DM.ExecQuery.CloseAll;
DM.ExecQuery.SQL.Clear;
DM.ExecQuery.DeleteVariables;
DM.ExecQuery.SQL.Add('select '+tbl+'.'+'*, '+tbl+'.rowid'+' from '+tbl+' '+whr);
DM.ExecQuery.Open;
DM.ExecQuery.Edit;
DM.ExecQuery.FieldByName(fld).AsString := params.items[3].AsString;
DM.ExecQuery.Post;
DM.ExecQuery is a TOracleDataset and the field I'm trying to store the data in is a Blob field. The whole sequence runs ok and setting 'debug=true' for DM.ExecQuery gives no error. Still no data is stored in the blobfield and I'm not able to find out why.
Any suggestions?
regards,
Martin
ps. I'm using a TOracleDataSet so I will not have to use a TLobLocator etc. This is what I understood from the manual as possible.