I have a Oracle database that store ArcSDE data.

 

I read mapinfo data with FME (MAPINFO reader)

 

And I write the data with FME (SDE30 writer)

 

I use : FME(R) 2012 SP4 (20120926 - Build 12266 - WIN32)

 

It's the same problem on server or desktop.

 

My problem is about an attribut.  It's a unique ID (ID_ORIGINE) that goes like this :

 

 

Mapinfo value : 7271203048662889

 

FME (logger) value :  Attribute(string)  : `ID_ORIGINE' has value `7271203048662889'

 

It's the same.  But when I open my ArcSDE table with ArcMap or visualize the data from within Oracle with SQL Developper I have this : 7271203048662890

 

The end of the number is rounded (2890 instead of 2889).  But I didn't ask for this.

 

 

My data structure :

 

Oracle : Number

 

SDE : Double (precision 38 and scale 10)

 

so it should go well cause If I insert it manually it's OK.

 

But when FME write it down : the value is rounded.

 

Is it FME that round the value while writing it down or Oracle or SDE that do the trick?

 

Any idea?

 

I know I can change the data structure but we are in PROD so change to database is not an option for now...