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
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users