9iLite Sync error....ORA-00932 Inconsistent datatypes

Hey all,

I am getting the following error when syncing between 9iLite and 8.1.7:

MS-9109 n_at_86e554 (this seems to be random string) || ORA-00932: inconsistent datatypes

Now, I've narrowed it down to the field that causes this error to occur. It is important to note that if I don't touch the field (just keep the initial value from the initial sync to 8.1.7, things sync fine.

The error only occurs if I change the field value in 9iLite (which I am doing through me eVB app).

In 9iLite it is defined as:

Data_Type = Number, Len = 5, N = Y, Prec = 5, Scale = 4

In 8.1.7 it is defined as:

Data_type = Number (5,4) Null = N

I'm not sure why in Lite null is Y and in 8.1.7 null is N. I just let Oracle create the lite tables based on my snapshot. At any rate, the field is not null.

Does anyone have any thoughts? Does anyone know what the first part (MS- 9109) of the error message is about? I can't find anything on it in Google.

Thx.

Darren Received on Wed Sep 03 2003 - 09:19:11 CDT