[mapserver-users] Query functions with Oracle Spatial

[Daiane Azevedo de Fraga]

Hello!

I tried to execute a query function through an interface. Appeared in the
logfile:
[Mon Apr 05 11:09:19 2010] msOracleSpatialLayerGetShape .621000 ():
OracleSpatial error. Error parsing OracleSpatial DATA is variable query. To
execute query functions you need to define one unique column [USING UNIQUE
<# column>]

I added the ID column, and now appears in the logfile:
[Mon Apr 05 11:11:47 2010] .358000 msOracleSpatialLayerGetShape ():
OracleSpatial error. Error: ORA-00932: inconsistent datatypes: expected %s
returned %s. Query statement: SELECT ID, NBLOCK, SECTOR, BLOCK, ORIGIN,
TYPE, NAME, SUPERCOURT, COURTS, OBSERVATION, AREA, REASON, DATA, REGISTRATION,
SE_ANNO_CAD_DATA, SHAPE FROM LOTS WHERE ID = 43,192. Check your statement
date.

 What can it be? It worked in some cases. The columns are apparently
right...
There may be some incompatibility factor?

Thanks!

--
Daiane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100405/47940429/attachment.html