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 attent
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