Opened 18 years ago

Last modified 16 years ago

#1172 closed defect

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

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 

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 (1)

by bartvde@…, 18 years ago

Attachment: ogr.tgz​ added

tgz file with Oracle SQL scripts and shell scripts

Note: See TracTickets for help on using tickets.