[gdal-dev] OCI: ogrinfo from normal table

[Sebastian E. Ovide]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20101115/a79b22c8/attachment.html