[gdal-dev] ogrinfo 1.10 with oracle view is failing

Rémy GOURRAT rgourrat at ag-carto.fr
Mon Mar 31 13:03:20 PDT 2014


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


More information about the gdal-dev mailing list