Re: [gdal-dev] Oracle OCI driver and Oracle views

2008-09-22 Thread Jim Klassen
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

[gdal-dev] Oracle OCI driver and Oracle views

2008-09-22 Thread Jukka Rahkonen
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