Error in drawquery with OracleSpatiall

Dominik Gierse gierse at SYSTEMTECHNIK.NET
Tue Apr 24 07:05:16 EDT 2007


Hello,

I´ve got a problem with my mapserver, but i can´t solve it.
The Data is stored in an Oracle-Database (10 g Enterprise, Oracle
Spatial). The connection to the database ist ok, i can show a map and
zoom in/out without any problems. But when i select an object, the
follwing error occurs: 

Warning: [MapServer Error]: msOracleSpatialLayerWhichShapes(): Error:
ORA-01002: FETCH auf ungültigen oder geschlossenen Cursor. . Query
statement: SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE
SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340891
9.23,5712065.41,3409949.2,5712837.89) ),'querytype=window') = 'TRUE' .
Check your data statement. in C:\ms4w\apps\hst\htdocs\map75.inc.php on
line 889 

Call Stack 
# Time Function Location 
1 1.0840 {main}( ) ..(null):0 
2 2.8869 gmapdrawmap( ) ..(null):464 
3 3.2150 ms_map_obj->drawquery( ) ..(null):889 

I can execute the SQL-Statement in a SQL-Client without any trouble and
get some records back. 
Here´s my Data-Statement in the map-filei:

LAYER
    NAME "tableitung"
    CONNECTIONTYPE oraclespatial
    CONNECTION "user/passwd at MYDB"
    DATA "GEOM FROM USER.TABLEITUNG USING UNIQUE EID"
    CLASSITEM "SK"

Can anybody tell me a way, how i can solve this problem ? 

Kind regards

Dominik Gierse



More information about the mapserver-users mailing list