[gdal-dev] Oracle OCI driver and Oracle views

Jim Klassen Jim.Klassen at ci.stpaul.mn.us
Mon Sep 22 09:06:44 EDT 2008

I have used OGR with oracle views regularly for a few years now. I agree that it works better when the view is registered in with *_sdo_geom_metadata (otherwise you have to mess around with the -sql option). Also, I do recall getting an error message like yours, however, I never paid much attention to it because ogr2ogr successfully performed the translation anyway.

Jim K

>>> Jukka Rahkonen <jukka.rahkonen at mmmtike.fi> 09/22/08 8:52 AM >>>

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-

gdal-dev mailing list
gdal-dev at lists.osgeo.org

More information about the gdal-dev mailing list