[gdal-dev] ogr2ogr error message with OracleSpatial View to Shape

[Rémy GOURRAT]

Hi,

When I use ogr2ogr to export data from Oracle Spatial View to shape,

With this syntax :

ogr2ogr -f "ESRI Shapefile" PARCELLE.shp OCI:ORA_USER/ORA_PWD at ORA_DATASOURCE:DGI.PARCELLE -sql "select * from DGI.PARCELLE where INSEE in (75001)" -skipfailures -overwrite

this message appears :

ERROR 1: ORA-04043: objet DGI.PARCELLE inexistant in OCIDescribeAny

This view is referenced in USER_SDO_GEOM_METADATA.

However, the export seems complete when I display it in Qgis : same geometry, same feature number than Oracle.

Is it a privilege issue or something else ?

Rémy Gourrat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140703/dff24fdf/attachment.html>