Opened 18 years ago

Last modified 16 years ago

#1172 closed defect

GDAL OVF OCI does not work with SrcSQL — at Version 2

Reported by: bartvde@… Owned by: Mateusz Łoskot
Priority: normal Milestone: 1.5.3
Component: OGR_SF Version: unspecified
Severity: normal Keywords: oracle oci
Cc: warmerdam

Description (last modified by warmerdam)

When using SrcSQL for an Oracle (OCI) table all coordinates are reported as 0 (using ogrinfo). When using a SrcLayer to a database view everything works fine.

ovf file used: 

<OGRVRTDataSource>
  <OGRVRTLayer name="calamiteitenoud">
<SrcDataSource>OCI:BVDE/BART@//rws-svl012i.int.storage.nwr.local:1521/TGEOS.rws.nl:VW_CALAMITEITEN_OUD</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>

I will attach a database script to create the tables and data.

Change History (3)

by bartvde@…, 18 years ago

Attachment: ogr.tgz​ added

tgz file with Oracle SQL scripts and shell scripts

comment:1 by warmerdam, 18 years ago 

Mateusz,

Could you try reproducing this?

comment:2 by warmerdam, 17 years ago

Cc: warmerdam added
Description: modified (diff)
Milestone: → 1.4.2
Priority: high → normal
Note: See TracTickets for help on using tickets.