tried... but still no luck... g...@mapserver:~$ ogrinfo OCI:la002/[email protected]/MFUATDB -sql 'Select T.Entry_Id as id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) as geom From Lookupindex T;' INFO: Open of `OCI:la002/[email protected]/MFUATDB' using driver `OCI' successful. ERROR 1: ORA-00911: invalid character in Select T.Entry_Id as id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) as geom From Lookupindex T;
note: the SQL query works well in Oracle SQL Developer... On Mon, Nov 15, 2010 at 3:52 PM, Michael Shishcu <[email protected]> wrote: > 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 >> > > -- Sebastian E. Ovide
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
