Blob problem

[brekhof]

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.

 

[Marco Kalter]

Perhaps you can use the Oracle Monitor to find out if any data is written to the BLOB?

------------------
Marco Kalter
Allround Automations

 

[brekhof]

Originally posted by mkalter:
Perhaps you can use the Oracle Monitor to find out if any data is written to the BLOB?

Should have thought about that myself..
I discovered a client that had a connection to the same table, I didn't think it had a lock but killing that program got me further. After tis I set the NullLOBIsEmpty to true and it looks like it is functioning.

thanks,
Martin

[This message has been edited by brekhof (edited 12 March 2001).]