UniConnection:
Direct := False;
Client + Server(UniDAC, Midas, UpWhereKey, Resovletodataset is false) + Oracle 11g
Problem:
Submitted data set contains multiple update field,Non-BLOB fields are updated, the BLOB field has not been updated,
Orace trance can be tracked to update BLOB field of the assignment statement, but written to the BLOB field is null/''，
If do not the Midas submit data, update and insert BLOB field is normal
I did wrong？？？ tks
clientdataset submitted delta is normal,
UniDAC 4.1.5 Oracle's BLOB fields can not be updated
hello,
For correct insertion of BLOB data, you should set the TemporaryLobUpdate option to False
UniQuery1.SpecificOptions.Values['TemporaryLobUpdate']:= 'false';
Since you have set the ResolveToDataSet property to False, a query for data insert is formed in ClientDataset and uses EMPTY_BLOB() for BLOB data insert, and when the TemporaryLobUpdate option is enabled - the EMPTY_BLOB is created once more, and an "empty" BLOB is transferred to a server.
For correct insertion of BLOB data, you should set the TemporaryLobUpdate option to False
UniQuery1.SpecificOptions.Values['TemporaryLobUpdate']:= 'false';
Since you have set the ResolveToDataSet property to False, a query for data insert is formed in ClientDataset and uses EMPTY_BLOB() for BLOB data insert, and when the TemporaryLobUpdate option is enabled - the EMPTY_BLOB is created once more, and an "empty" BLOB is transferred to a server.