[gdal-dev] OCI: ogrinfo from normal table

[Michael Shishcu]

Hi Sebastian

maybe Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_
POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL)* AS* geom From Lookupindex
T; ?

regards, michael


On 15 November 2010 17:46, Sebastian E. Ovide <sebastian.ovide at gmail.com>wrote:

> Hi All,
>
> I have a table which has an X and Y columns. It doesn't have a geometry
> column.
>
> In order to read geometries created on the fly, I'm trying to use ogrinfo
> with the -sql parameter.
>
> So the Oracle query is:
>
>  Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord,
> T.Ycoord, NULL), NULL, NULL) geom From Lookupindex T;
>
> and therefore the ogrinfo command is:
>
>  ogrinfo OCI:la002/la002 at 192.168.60.70/MFUATDB -sql 'Select T.Entry_Id id,
> SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL)
> geom From Lookupindex T;'
>
> I would expect a list of points... but I'm getting this:
>
>
> INFO: Open of `OCI:la002/la002 at 192.168.60.70/MFUATDB'
>       using driver `OCI' successful.
> ERROR 1: ORA-00911: invalid character
>  in Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord,
> T.Ycoord, NULL), NULL, NULL) geom From Lookupindex T;
>
>
> any ideas ?
>
>
> --
> Sebastian E. Ovide
>
>
>
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20101115/58a5bc1c/attachment.html