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. > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
