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/[EMAIL PROTECTED]" -sql "Select * from tblinputs_v where tileid=247
> " -nlt POLYGON
>
> Rgds.
>
> Abhay.
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
