Problem with Oracle Spatial

[Fernando Simon]

Hi,
    The problem is not with oracle table. I believe that the problem
is with the MIGRATE procedure. After you import your data, did you
executed the "EXECUTE SDO_MIGRATE.TO_CURRENT('<your table>','<geom
column>');" procedure in sqlplus?
    If you don't execute this procedure after import the data with
shp2sdo the mapserver don't draw any data from oracle.
    Thanks.

----------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada
http://g10.cttmar.univali.br
----------------------------------------------------------------

Citando Lorena Medellin <lorena_medellin at YAHOO.ES>:

> Hi,
>
> I have Oracle EE 9.2.0.1.0 with Oracle Spatial, I loaded a layer
> with shp2sdo to oracle spatial. The USER_SDO_GEOM_METADATA table is
> ok.
>
> Then I install mapserver4.4.0-oracle binary and my mapfile is:
>
>  NAME MANIZALES
>   STATUS ON
>   SIZE 300 200
>   EXTENT  1169230 1047365 1183658 1056453
>   UNITS METERS
>   IMAGECOLOR 255 255 255
>   IMAGETYPE PNG
>
>  LAYER
>     NAME BARRIO
>     TYPE POLYGON
>     CONNECTIONTYPE oraclespatial
>     CONNECTION "system/oracle at dbtitan"
>     DATA "GEOMETRIE FROM (SELECT GEOMETRIE FROM BARRIO)"
>     DUMP TRUE
>     CLASS
>      OUTLINECOLOR 0 0 0
>      COLOR 0 128 128
>     END
>   END
> END
>
> and when I tried to connect by browser there is a problem,
> mapserver doesn't show me the image, I used mode map:
>
http://titan/cgi-bin/mapserv.exe?map=C:\apache\Apache2\htdocs\oracle\manizales.map&mode=map
>
> Please, help me!
>
> Regards
>
> Lorena
>
>
> Elsa Lorena Medellin V.
>
>
> ---------------------------------
>
>




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br