[mapserver-dev] [Oracle] Query filter

[Guillaume BARTHE]

Hi,

I try interface mapserver and oracle with stored procedure like :

DATA "VGEO FROM (SELECT * FROM TABLE(PK_TEST.FILTRER(33,36))) USING SRID 
4326 VERSION 10g"

Mapserver return :
"
msDrawMap(): Image handling error. Failed to draw layer named 'sipad'. 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: 
ORA-00600: internal error code, arguments: [koksccd1], [0], [], [], [], 
[], [], [] . Query statement: SELECT rownum, VGEO FROM (SELECT * FROM 
TABLE(PK_TEST.FILTRER(33,36))) WHERE SDO_FILTER( VGEO, 
MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates 
),'querytype=window') = 'TRUE' . Check your data statement.
"

This syntax is a standart oracle, why mapserver doasen't permit it ?

Thank you for answering.

Guillaume


-- 
<www.c-s.fr> 	*Guillaume BARTHE*
Ingénieur d'étude sur KHEPER

*CS Systèmes d'Information - Division Espace & Renseignement*
Département Information Géographique & Image
Parc de la Grande Plaine - 5, Rue Brindejonc des Moulinais - BP 15872
31506 Toulouse Cedex 05 - FRANCE
Tel : +33 561 17 63 70
Email : guillaume.barthe at c-s.fr

-------------- next part --------------
Skipped content of type multipart/related