[gdal-dev] OCI: ogrinfo from normal table

[Sebastian E. Ovide]

tried... but still no luck...

gis at mapserver:~$ ogrinfo OCI:la002/la002 at 192.168.60.70/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/la002 at 192.168.60.70/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 <micklesh at gmail.com> 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 <sebastian.ovide at gmail.com>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/la002 at 192.168.60.70/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/la002 at 192.168.60.70/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
>> gdal-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>>
>
>


-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20101115/abd77ce5/attachment.html