Re: [Gdal-dev] GDAL OGR2OGR does not export Oracle Views

2008-08-08 Thread D
Hello Abhay, here is what I have also tried to get rid of the error message. > PS. OCIDescribeAny error occur when you create a entry in USER_SDO_GEOM_METADATA for the VIEW in use. I did insert the metadata afterwards, but did not help. Here is the insert statement INSERT INTO USER_SDO_GEOM

Re: [Gdal-dev] GDAL OGR2OGR does not export Oracle Views

2008-08-07 Thread Mateusz Loskot
Dejan Gregor wrote: Hi Mateusz, thanks for your reply. I have ran the command and got a response: C:\>ogrinfo "OCI:maribor/[EMAIL PROTECTED]:MARIBOR.WA_PIPE_VIEW" ERROR 1: ORA-04043: object MARIBOR.WA_PIPE_VIEW does not exist in OCIDescribeAny INFO: Open of `OCI:maribor/[EMAIL PROTECTED]:MARIBO

Re: [Gdal-dev] GDAL OGR2OGR does not export Oracle Views

2008-08-07 Thread Dejan Gregor
Hi Mateusz, thanks for your reply. I have ran the command and got a response: C:\>ogrinfo "OCI:maribor/[EMAIL PROTECTED]:MARIBOR.WA_PIPE_VIEW" ERROR 1: ORA-04043: object MARIBOR.WA_PIPE_VIEW does not exist in OCIDescribeAny INFO: Open of `OCI:maribor/[EMAIL PROTECTED]:MARIBOR.WA_PIPE_VIEW'

Re: [Gdal-dev] GDAL OGR2OGR does not export Oracle Views

2008-08-06 Thread Mateusz Loskot
Dejan Gregor wrote: > Hi, > > I am trying to export an Oracle view (11g) that is made of an Oracle spatial > geometry carrier and an ordinary Oracle table to a Shapefile. so what I want > to export is an Oracle view. > > C:\>ogr2ogr -f "ESRI Shapefile" WA_PIPE "OCI:/[EMAIL > PROTECTED]:MARI

[Gdal-dev] GDAL OGR2OGR does not export Oracle Views

2008-08-06 Thread Dejan Gregor
Hi, I am trying to export an Oracle view (11g) that is made of an Oracle spatial geometry carrier and an ordinary Oracle table to a Shapefile. so what I want to export is an Oracle view. C:\>ogr2ogr -f "ESRI Shapefile" WA_PIPE "OCI:/[EMAIL PROTECTED]:MARIBOR.WA_PIPE_ VIEW" ERROR 1: ORA-