[mapserver-users] [EXTERNAL] Failed to draw Oracle9i layer

[Smith, Michael ERDC-RDE-CRREL-NH]

Francisco,

Change your DATA statement to be :  DATA "MI_SHAPE FROM CONSEJOSPOPULARES using SRID 4326"

Eg, remove the = sign.

Mike
----
Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.smith at usace.army.mil


From: Francisco Salas Rosette <fsalas at pinar.geocuba.cu<mailto:fsalas at pinar.geocuba.cu>>
Date: Monday, June 1, 2015 at 8:08 AM
To: mapserver-users <mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>>
Subject: [EXTERNAL] [mapserver-users] Failed to draw Oracle9i layer
Resent-From: Michael Smith <michael.smith at usace.army.mil<mailto:michael.smith at usace.army.mil>>

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<mailto: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/a3c82909/attachment.html>