[Gdal-dev] problem using OCI ovf

[Bart van den Eijnden (OSGIS)]

Hi list,

using last week's CVS I am trying to access an ovf point layer in Oracle.
In Oracle the X and Y columns are of type NUMBER(22,0).

OGR reports all X and Y values as 0 but in the database the correct values
are present:

CALX     CALY
 -------  -------
 33219    669433
 -452425  913701
 28883    691114
 184983   665097
 66463    776391
 72244    709904
 -452425  913701
 79471    654979
 73545    515742

Ogrinfo reports:
CALX: Integer (0.0)
CALY: Integer (0.0)

And:
  CALX (Integer) = 0
  CALY (Integer) = 0
  ..
  POINT (0 0 0)

Any ideas what could be going wrong?

The ovf file:
<OGRVRTDataSource>
    <OGRVRTLayer name="calamiteitenoud">
       <SrcDataSource>OCI:BVDE/BART@//xxx:1521/TGEOS.rws.nl:CALAMITEITEN</SrcDataSource>
        <SrcSQL>SELECT * FROM CALAMITEITEN WHERE ACTUEEL = 0</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>EPSG:28992</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="CALX" y="CALY"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

Thanks in advance.

Best regards,
Bart