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

[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_METADATA
VALUES (
'WA_PIPE_VIEW',
'GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', 300000, 650000, 0.0005),
MDSYS.SDO_DIM_ELEMENT('Y', 20000, 200000, 0.0005),
MDSYS.SDO_DIM_ELEMENT('Z', -10, 10000, 0.0005)),
'5000000');
COMMIT;


Best regards,
Dejan

 > And my implementation looks like this
>
> C:\Dev\gdal\bld152\bin>ogr2ogr -f "ESRI Shapefile" test.shp
"OCI:xxxxxxx/xxxxxxx at pilot" -sql "Select * from tblinputs_v where tileid=247
> " -nlt POLYGON
>
> Rgds.
>
> Abhay.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20080808/259ab253/attachment-0001.html