Question

SDE and Oracle data

  • 12 February 2014
  • 2 replies
  • 5 views

Badge +1

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...

 

 

 

 

2 replies

Userlevel 3
Badge +13
Hi, when writing to an FFS is the value rounded? if that is the case than its probably FME otherwise the target database, that would be my initial test.
Badge +1
thanks for the reply.

 

The ffs contains the value as it should be : 7271203048662889

 

Is it SDE or Oracle? 

Reply