[gdal-dev] Oracle OCI driver and Oracle views

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Mon Sep 22 09:52:01 EDT 2008


I tried to convert data from Oracle spatial view (not table) with ogr2ogr. 
Result was not successful.  Instead I got this message:

ERROR 1: ORA-04043: object MY_VIEW does not exist
 in OCIDescribeAny

The view exists in the database, it is registered in ALL_SDO_GEOM_METADATA and I
can use it through SQL.  Now I wonder if ogr2ogr OCI driver supports the use of
Oracle views at all. The documentation at http://gdal.org/ogr/drv_oci.html does
not say anything about views.

-Jukka Rahkonen-

More information about the gdal-dev mailing list