[gdal-dev] Oracle OCI driver and Oracle views
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.
>>> 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
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.
gdal-dev mailing list
gdal-dev at lists.osgeo.org
More information about the gdal-dev