Hi Rémy, If you inserted table_name and column_name in uppercase into the user_sdo_geom_metadata it should works. You should be able to run "ogrinfo oci:user/pwd@db" and see that after the ORA-04043 error the view will be listed as a layer anyway. Try also "ogrinfo oci:user/pwd@db <view name>". And if you want to debug it you can add "--debug on" at the end of the command.
Regards, Ivan > From: rgour...@ag-carto.fr > To: gdal-dev@lists.osgeo.org > Date: Mon, 31 Mar 2014 20:03:20 +0000 > Subject: [gdal-dev] ogrinfo 1.10 with oracle view is failing > > Hi, > > I do an ogrinfo on oracle view. > > Ogrinfo return ora-04043 object don't exist > > i do the same command on the native table with success. > > So i check the metadata in user_sdo_geom_metadata, it's same metadata for the > view and the table. > > I recompile the view to have exactly same fields, same tablespace... in the > view that the table (create myview as select * from mytable) > > But it's always the same issue : > Ora-04043... > > I use : > Ogrinfo 1.10 (from Qgis 2.0.1) > Oracle instant client 12 64bits > Oracle database 10g2 > > In sqldevelopper with the same user used with ogrinfo i can : > - describe the view > - select > -... > > Thanks for your advice > > Remy > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
