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.sm...@usace.army.mil From: Francisco Salas Rosette <fsa...@pinar.geocuba.cu<mailto:fsa...@pinar.geocuba.cu>> Date: Monday, June 1, 2015 at 8:08 AM To: mapserver-users <mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org>> Subject: [EXTERNAL] [mapserver-users] Failed to draw Oracle9i layer Resent-From: Michael Smith <michael.sm...@usace.army.mil<mailto:michael.sm...@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 andari...@geosi.geocuba.cu<mailto:andari...@geosi.geocuba.cu> o por el tel?fono 8817400. Ponga su informaci?n al servicio de todos.
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
