[gdal-dev] ogr2ogr Shap to OCI ora-01438 value larger...

[Even Rouault]

Le lundi 27 octobre 2014 16:09:52, vous avez écrit :
> Hi,
> 
> When i try to import a Shape with ogr2ogr and OCI  and this command line :
> 
> Before, i execute this command line to keep the accents:
> 
> SET NLS_LANG=American_America.UTF8
> 
> And just after :
> 
> ogr2ogr -f OCI OCI:****/****@****:ZZ_SHP_DOC_URBA
> "G:\temp\shp\shape_L93CC44\40243_DOC_URBA_L93CC44.shp" -nln
> ZZ_SHP_DOC_URBA -overwrite
> 
> I have this error message "ERROR 1: ORA-01438: value larger than specified
> precision allowed for this column"
> 
> So I modify like this ignoring  the SHAPE_AREA field :
> 
> ogr2ogr -f OCI OCI:ORA_PLU20/3717grade at Ag_GeoPLU:ZZ_SHP_ZONE_URBA -select
> TEX2,INSEE,IDURBA,DATAPPRO,DATVALID,TYPEDOC,DATEFIN,INTERCO,SIREN,ETAT,NOM
> REG,URLREG,NOMPLAN,URLPLAN,SITEWEB,TYPEREF,DATEREF
> "G:\temp\shp\shape_L93CC44\40243_ZONE_URBA_L93CC44.shp" -nln
> ZZ_SHP_DOC_URBA -nlt PROMOTE_TO_MULTI -overwrite
> 
> So i can identify the field problem cause  : "SHAPE_AREA"
> 
> In the shape via Qgis, i see the property field : double - real - 19 - 11,
> in oracle I see also  SHAPE_AREA NUMBER(19,11)
> 
> in Qgis the shape Area value is : 117839075.90299999714 (9 + 11 = 20
> caracters)
> 
> I think it is a problem with the decimal character
> 
> and UTF-8 but I thought to resolve it with SET
> NLS_LANG=American_America.UTF8

Rémi,

This looks like http://trac.osgeo.org/gdal/ticket/2667

Can perhaps be workarounded by adding -lco PRECISION=NO

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com