tried... but still no luck...<div><br></div><div><div>gis@mapserver:~$ ogrinfo OCI:la002/<a href="http://la002@192.168.60.70/MFUATDB">la002@192.168.60.70/MFUATDB</a> -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;'</div>
<div>INFO: Open of `OCI:la002/<a href="http://la002@192.168.60.70/MFUATDB">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 as id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL) as geom From Lookupindex T;</div><div><br></div><div><br></div><div>note: the SQL query works well in Oracle SQL Developer...</div>
<br><div class="gmail_quote">On Mon, Nov 15, 2010 at 3:52 PM, Michael Shishcu <span dir="ltr"><<a href="mailto:micklesh@gmail.com">micklesh@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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">
<div><div></div><div class="h5">
On 15 November 2010 17:46, Sebastian E. Ovide <span dir="ltr"><<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><div></div><div class="h5">
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></div></div>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">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>
</blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br>
</div>