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 <[EMAIL PROTECTED]> 09/22/08 8:52 AM >>> Hi, 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 [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
