TCRBatchMove with TOraNumber Field

easyblue · Post by **easyblue** » Sat 08 Jan 2011 03:01

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:

Code: Select all

DestField.AsString := SrcField.AsString;

Since you have defined this TOraNumber type, so please add suport of this type in the "CASE" block.

AlexP · Post by **AlexP** » Mon 10 Jan 2011 08:31

Hello,

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

easyblue · Post by **easyblue** » Tue 11 Jan 2011 07:47

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.

AlexP · Post by **AlexP** » Tue 11 Jan 2011 09:46

Hello,

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

bork · Post by **bork** » Fri 14 Jan 2011 14:03

Hello

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