Hi Sebastian<br><br>maybe Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_<div>POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL)<b> AS</b> geom From Lookupindex T; ?<br><br>regards, michael<br></div><br><br><div class="gmail_quote">
On 15 November 2010 17:46, Sebastian E. Ovide <span dir="ltr"><<a href="mailto:sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi All,<div><br></div><div>I have a table which has an X and Y columns. It doesn't have a geometry column.</div><div><br></div><div>In order to read geometries created on the fly, I'm trying to use ogrinfo with the -sql parameter.</div>
<div><br></div><div>So the Oracle query is:</div><div><br></div><div><div> Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) geom From Lookupindex T;</div></div><div><br></div>
<div>and therefore the ogrinfo command is:</div><div><br></div><div><div> ogrinfo OCI:la002/<a href="http://la002@192.168.60.70/MFUATDB" target="_blank">la002@192.168.60.70/MFUATDB</a> -sql 'Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) geom From Lookupindex T;'</div>
</div><div><br></div><div>I would expect a list of points... but I'm getting this:</div><div><br></div><div><br></div><div><div>INFO: Open of `OCI:la002/<a href="http://la002@192.168.60.70/MFUATDB" target="_blank">la002@192.168.60.70/MFUATDB</a>'</div>
<div> using driver `OCI' successful.</div><div>ERROR 1: ORA-00911: invalid character</div><div> in Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) geom From Lookupindex T;</div>
</div><div><br></div><div><br></div><div>any ideas ?</div><div><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>
</div>
<br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br>