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

[Rémy GOURRAT]

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,NOMREG,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

but no...

thanks for your help.

Rémy

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20141027/237ff8e7/attachment.html>