Error in drawquery with OracleSpatiall
Dominik Gierse
gierse at SYSTEMTECHNIK.NET
Tue Apr 24 04:05:16 PDT 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