Devart Forums

Hello

It seems that TCRBatchMove does not support for dest field of type TOraNumber.

In case of the dest field is of tye TOraNumber, TCRBatchMove seems to have a problem to update successfully for using AsVariant

I have made a quick change (using AsString) at line 385 to have a quick-dirty solve:
Since you have defined this TOraNumber type, so please add suport of this type in the "CASE" block.

Hello,

Please specify the problems that arise when you are using TCRBatchMove with the TOraNumber fields?
Also please specify the exact version of ODAC.

Hello

version MyDAC v6.0.0.3+ODAC v7.0.0.3
and BDS2006.

I was moving data from MySQL into Oracle using TCRBatchMove.

In case the source field (in MySQL) is of TLargeInt (bigint) type, and dest field (in Oracle) is of TOraNUmber (ftNUmber) type, then I have AV of

"Cannot convert type"

At that time I have changed source code of TCRBatchMove of line 385 to cast both into String instead of Variant to solve this problem.

Please kindly review it.

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.

Hello

We have fixed this issue. This fix will be included in the next ODAC build.