<HTML>
<HEAD>
<TITLE>Re: [mapserver-users] Query functions with Oracle Spatial</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Daiane,<BR>
<BR>
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.<BR>
<BR>
Mike<BR>
<BR>
<BR>
-- <BR>
Michael Smith<BR>
RSGIS Center<BR>
US Army Corps of Engineers<BR>
<BR>
<BR>
<BR>
On 4/5/10 12:33 PM, "Daiane Azevedo de Fraga" <<a href="daiane.a.fraga@gmail.com">daiane.a.fraga@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hello!<BR>
</SPAN></FONT><SPAN STYLE='font-size:11pt'><FONT COLOR="#000066"><FONT FACE="Verdana, Helvetica, Arial"><BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial">I tried to execute a query function through an interface. Appeared in the logfile: <BR>
[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>] <BR>
<BR>
I added the ID column, and now appears in the logfile:<BR>
[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.<BR>
</FONT><FONT COLOR="#000066"><FONT FACE="Verdana, Helvetica, Arial"><BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial">What can it be? It worked in some cases. The columns are apparently right...<BR>
There may be some incompatibility factor?<BR>
<BR>
Thanks!<BR>
<BR>
--<BR>
Daiane<BR>
<BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></FONT></SPAN><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
mapserver-users mailing list<BR>
<a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>