[mapserver-users] Failed to draw Oracle9i layer

[Francisco Salas Rosette]

Hi,

I am having trouble making one test with loading the Oracle9i layer , using
PHP Version 5.4.3 and MapServer CGI 6.0.3 

The layer definition in my map file is :

LAYER

    NAME Consejo_Popular

    TYPE POLYGON

STATUS ON

    CONNECTIONTYPE oraclespatial

    CONNECTION "******/*****@catastro"

    DATA "MI_SHAPE FROM CONSEJOSPOPULARES using SRID=4326"

    DUMP TRUE

    CLASS 

     OUTLINECOLOR          0 0 0

     COLOR 0 128 128

    END 

  END  

 

I use this "Steps to Enable Oracle 10g or 11g Support in MS4W" , but I test
in oracle9i 

 

And launch this error message , 

 

Warning: mapObj::draw(): [MapServer Error]: msDrawMap(): Failed to draw
layer named 'Consejo_Popular'. in
C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on
line 108

 

Warning: mapObj::draw(): [MapServer Error]:
msOracleSpatialLayerWhichShapes(): Error: ORA-29902: error in executing
ODCIIndexStart() routine ORA-01722: invalid number . Query statement: SELECT
rownum, MI_SHAPE FROM CONSEJOSPOPULARES WHERE SDO_FILTER( MI_SHAPE,
MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE' . Check your data statement. in
C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on
line 108

 

How resolve this problems ??

 

Thanks , 

 

Francisco Salas 


----------------------------------------------------------------------------------------------------
Anuncie sus servicios en ANDARIEGO… aplicación para celulares sobre mapas de toda Cuba.  
Visite el sitio http://andariego.geocuba.cu o http://www.andariego.cu, contáctenos por el correo andariego at geosi.geocuba.cu o por el teléfono 8817400. 
Ponga su información al servicio de todos.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150601/298df077/attachment.htm>