Daiane, What version of Mapserver are you using? I suspect a version before 5.4 ( I think that is when it changed ). The SE_ANNO_CAD_DATA field is a BLOB and not a supported return type for queries. You can either upgrade to a newer version of Mapserver which excludes BLOB fields or you can write a view to exclude that column and query the view.
Mike -- Michael Smith RSGIS Center US Army Corps of Engineers On 4/5/10 12:33 PM, "Daiane Azevedo de Fraga" <daiane.a.fr...@gmail.com> wrote: > 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
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users