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 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
