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">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">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>