[gdal-dev] Re: ogr2ogr (1.8.2) error cannot fetch a layer

[Jukka Rahkonen]

hdam99 <at> gmail.com <hdam99 <at> gmail.com> writes:

> 
> Hi,
> 
> I'm using ogr2ogr to get data from a oracle view (11g2) to a gml (3.1) file. 
> The gml file was created as expected even I got the ERROR1: ORA-04043:
> object blah does not exist errors.
> 
> Why did I get those errors even though they are in the database?
> 
> There are two views that I didn't have any data.  One of them has additional
> error "FAILURE: Couldn't fetch requested layer 'AIRWAY'!  
> 
> What would be the cause and would be there any work around?
hdam99 <at> gmail.com <hdam99 <at> gmail.com> writes:

> 
> Hi,
> 
> I'm using ogr2ogr to get data from a oracle view (11g2) to a gml (3.1) file. 
> The gml file was created as expected even I got the ERROR1: ORA-04043:
> object blah does not exist errors.
> 
> Why did I get those errors even though they are in the database?
> 
> There are two views that I didn't have any data.  One of them has additional
> error "FAILURE: Couldn't fetch requested layer 'AIRWAY'!  
> 
> What would be the cause and would be there any work around?

ORA-error is coming from the database but I fear with this information not much
more can be said. For having something to start with, could you provide us

- The CREATE VIEW you have used
- What you have in the USER_SDO_GEOM_COLUMNS about the new view
- What does ogrinfo list about the view?
- Is the Oracle user who created the view the same as the ogr2ogr user? If
not,what rights does ogr2ogr user have for the view?


> Thanks - H
> 
> --
> View this message in context:
http://osgeo-org.1803224.n2.nabble.com/ogr2ogr-1-8-2-error-cannot-fetch-a-layer-tp6854910p6854910.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
>