OracleSpatial QueryAttribute

[Hallgren Johan E]

Hello,

 

No I have tried the OracleSpatial Native support. Everything works fine
until I try to queryAttributes. 

 

I don't get the expected results but I can se that the following SQL is
sent to Oracle.:

 

--------------------------

SELECT OBJECTID, , shape FROM (SELECT objectid, shape, fnr_fds FROM
bergvikmark_sdo) WHERE FNR_FDS = '200205688' AND SDO_FILTER(
shape, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(70420.
8121,6043080.13,3097864.19,7727610.88) ),'querytype=window') = 'TRUE'

--------------------------

 

As I can see the problem is in the beginning, "SELECT OBJECTID, ,". I
tried to look at the code and in maporaclespatial.c/
msOracleSpatialLayerWhichShapes() (I think that's functions is used)

 

I don't understand what's wrong...

 

I'm using mapserver-4.8.1

Oracle 10.1 (windows Server)

I'm using the MapScript api.

 

MapFile:

CONNECTION "wmgis/xxx at wmsi1394"

CONNECTIONTYPE oraclespatial 

DATA "shape FROM (SELECT objectid, shape, fnr_fds FROM bergvikmark_sdo)
USING UNIQUE OBJECTID VERSION 10g" 

 

I have also tried the 

DATA "shape FROM bergvikmark_sdo USING UNIQUE OBJECTID VERSION 10g" 

 

But the same result.

 

Any ideas?

 

/Johan

___________________________________


Johan Hallgren
WM-data


Pelle Bergs backe 3
Box 1938, 791 19 Falun
Tel: 023-844 65 (int: +46-2384465)
Mobil: 070-588 44 28 (int: +46-705884428)
johan.e.hallgren at wmdata.com
<BLOCKED::mailto:johan.e.hallgren at wmdata.com> 
http://www.wmdata.se <BLOCKED::http://www.wmdata.se> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20060224/7d48fd3a/attachment.html