[mapserver-users] R: Re: oraclespatial connection

[Jeff McKenna]

Hello,

I have an old local 10g instance that I use for testing.  My LAYER contains:

    CONNECTIONTYPE oraclespatial
    CONNECTION "jeff/marvin at geo"
    DATA "ORA_GEOMETRY FROM (SELECT ORA_GEOMETRY FROM PARK)" 

I often do testing for layers through OGR first, using the ogrinfo
commandline utility, such as:

    ogrinfo OCI:jeff/marvin

    and

    ogrinfo OCI:jeff/marvin at geo PARK -summary

That way I can see the correct name of the geometry column, or extents, or
other details.

-jeff




--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com




miki79 wrote
> 
> LAYER 
> 
>     NAME PSITDATA.COMUNI 
> 
>     TYPE POLYGON 
> 
>     CONNECTIONTYPE oraclespatial
> 
>     CONNECTION "UN/PW at DBSVILPU" 
> 
>     DATA "SHAPE FROM PSITDATA.COMUNI USING SRID 32633 VERSION 10g" 
> 
>     CLASS 
> 
>         STYLE 
> 
>             OUTLINECOLOR 0 0 0 
> 
>             COLOR 0 128 128 
> 
>         END 
> 
>     END 
> 
>         METADATA 
> 
>       "wms_title"    "PSITDATA.COMUNI" 
> 
>       #"wms_srs"             "EPSG:26591" 
> 
>       "wms_srs"              "EPSG:32633"       
> 
>       "wms_name"            "PSITDATA.COMUNI" 
> 
>       "wms_server_version"  "1.1.1" 
> 
>       "wms_format"          "image/png" 
> 
>       "wms_enable_request" "*"   ##necessary 
> 
>         END 
> 
>         PROJECTION 
> 
>           "init=epsg:32633" 
> 
>         END 
> 
> END 
> 




--
View this message in context: http://osgeo-org.1560.n6.nabble.com/R-Re-oraclespatial-connection-tp4996421p4996426.html
Sent from the Mapserver - User mailing list archive at Nabble.com.