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

[Ivan Lucena]

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 at db" and see that after the ORA-04043 error the view will be listed as a layer anyway. Try also "ogrinfo oci:user/pwd at db <view name>". And if you want to debug it you can add "--debug on" at the end of the command.

Regards,

Ivan

> From: rgourrat at ag-carto.fr
> To: gdal-dev at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140331/4dd40ade/attachment.html>