<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>Dear GDAL developer,</div>
<div> </div>
<div> I run this command (GDAL 2.0.2, released 2016/01/26)</div>
<div> </div>
<div>ogr2ogr -f "ESRI Shapefile" Test2.shp OCI:user/pwd@instance -sql "SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604)"</div>
<div> </div>
<div> And I get </div>
<div> </div>
<div>Warning 1: Value '.0192' of field SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604).SURF_HA parsed incompletely to integer 0.</div>
<div>Warning 1: Value '10.1964' of field SELECT RID, ROUND(sdo_geom.sdo_area (s.geom, 0.01) / 10000,4) SURF_HA, s.GEOM FROM SIG_SOCS s WHERE RID IN (7778067,8644604).SURF_HA parsed incompletely to integer 10.</div>
<div> </div>
<div> SURF_HA seems interpreted as integer instead of real value.</div>
<div> Is there a way to force SURF_HA to interpreted as real with 4 decimal ?</div>
<div> </div>
<div> Thanks for your hint</div>
<div> </div>
<div>Nicolas Simon</div>
<div> </div>
</span></font>
</body>
</html>