Blob problem in oracle

zvasku · Post by **zvasku** » Wed 08 Oct 2008 13:21

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

zvasku · Post by **zvasku** » Wed 08 Oct 2008 13:39

in Direct mode ApplyUpdates hangs with ORA-22275 invalit LOB locator specified and ORA-06512

Plash · Post by **Plash** » Wed 08 Oct 2008 13:45

You should set the TemporaryLobUpdate provider specific option in TUniQuery to False.

zvasku · Post by **zvasku** » Wed 08 Oct 2008 13:54

I have no setting like this. If I set it to false. This does not help. Still error.

Plash · Post by **Plash** » Thu 09 Oct 2008 09:18

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.