Page 1 of 1
Blob problem in oracle
Posted: Wed 08 Oct 2008 13:21
by zvasku
Hello,
there is a problem with TClientDataset-TDatasetProvider-TUniQuery. Blob fields are not updated, there are always null. All other fields are ok.
D2006 Pro+UniDAC 1.0.0.10+Oracle 10g/11g
Thanks
Zdenek
Posted: Wed 08 Oct 2008 13:39
by zvasku
in Direct mode ApplyUpdates hangs with ORA-22275 invalit LOB locator specified and ORA-06512
Posted: Wed 08 Oct 2008 13:45
by Plash
You should set the TemporaryLobUpdate provider specific option in TUniQuery to False.
Posted: Wed 08 Oct 2008 13:54
by zvasku
I have no setting like this. If I set it to false. This does not help. Still error.
Posted: Thu 09 Oct 2008 09:18
by Plash
Setting the TemporaryLobUpdate to False should help (TemporaryLobUpdate is not supported for using with TClientDataSet).
If it doesn't help, please send to unidac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.