Error in drawquery with OracleSpatiall

[Fernando Simon]

Hi Dominik,
    Are you trying to use a query just to draw? What are the steps that 
you followed to apply the query?
    Can you pass the PHP code that generate the error?
    You can try to use the debug mode (DEBUG ON) for your layer to see 
all the functions that Mapserver used until the error.
    Best regards.

--------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer
--------------------------------------------------

Dominik Gierse wrote:
> 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
>
>