[mapserver-dev] [Oracle] Query filter

[Guillaume BARTHE]

I think it's an oracle bug because :
DATA "VGEO FROM (SELECT * FROM TABLE(PK_TEST.FILTRER(33,36))) USING 
NONE; works.

I use Oracle 10.2.0.3-0 :
SELECT * FROM TABLE(PK_TEST.FILTRER(33,36));  ==> OK !
SELECT * FROM TA_GEOATTRIBUTE_VALUE WHERE AGEOATTRIBUTE_VALUE_ID BETWEEN 
33 AND 36;  ==> OK !

SELECT ROWNUM, VGEO FROM (SELECT * FROM TABLE(PK_TEST.FILTRER(33,36)));  
==> OK !
SELECT ROWNUM, VGEO FROM (SELECT * FROM TA_GEOATTRIBUTE_VALUE WHERE 
AGEOATTRIBUTE_VALUE_ID BETWEEN 33 AND 36);  ==> OK !

SELECT ROWNUM, VGEO FROM (SELECT * FROM TA_GEOATTRIBUTE_VALUE WHERE 
AGEOATTRIBUTE_VALUE_ID BETWEEN 33 AND 36) WHERE ROWNUM = 1;  ==> OK !
SELECT ROWNUM, VGEO FROM (SELECT * FROM TABLE(PK_TEST.FILTRER(33,36))) 
WHERE ROWNUM = 1;  ==> OK !

SELECT ROWNUM, VGEO FROM (SELECT * FROM TA_GEOATTRIBUTE_VALUE WHERE 
AGEOATTRIBUTE_VALUE_ID BETWEEN 33 AND 36) WHERE SDO_FILTER( VGEO, 
NULL,'querytype=window') = 'TRUE';  ==> OK !
SELECT ROWNUM, VGEO FROM (SELECT * FROM TABLE(PK_TEST.FILTRER(33,36))) 
WHERE SDO_FILTER( VGEO, NULL,'querytype=window') = 'TRUE';  ==> NOK :

ORA-00600: internal error code, arguments: [koksccd1], [0], [], [], [], 
[], [], []
00600. 00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], 
[%s], [%s], [%s], [%s]"
*Cause:    This is the generic internal error number for Oracle program
           exceptions.    This indicates that a process has encountered an
           exceptional condition.
*Action:   Report as a bug - the first argument is the internal error number

Guillaume


Guillaume BARTHE a écrit :
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>   

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