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 <[email protected]>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/[email protected]/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/[email protected]/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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
