[Mapserver-users] Oracle 9i Support

[Bart van den Eijnden]

Hi Chris,

can you post the Oracle LAYER from your map file?

Best regards,
Bart

On Mon, 15 Dec 2003 12:34:26 -0800, <chodgson at refractions.net> wrote:

> I'm having a problem using Mapserver 3.6.3 with Oracle 9i. None of the
> geometries from oracle are displayed on the map. It gives me no error 
> message,
> they're simply not displayed.
>
> I believe my connection string and query are correct
> (user/pass at tnsname, "the_geom from table"). If I make an error in the 
> table
> name, then take the resulting query which is given in the mapserver error
> message and correct the table name, then run it in sqlplus, I get the 
> correct
> results.
>
> Mapserver is compiled with oracle support and it says 
> INPUT=ORACLESPATIAL in
> the version string. Other, shapefile-based layers are displayed 
> correctly even
> as the oracle layer is not. I have the layer set as default, and there 
> is no
> min/maxscale set so I know it should be displayed.
>
> I loaded the data by taking a shapefile, running shp2sdo (downloaded from
> oracle) and then sqlldr (from the oracle client tools install). I didn't
> specify an SRID anywhere, and mapserver isn't compiled with Proj 
> support, but I
> can see my shapefile layers displayed correctly and they are in the same
> projection as the oracle data (BC Albers). Is there any issues with not 
> giving
> oracle and SRID (it seemd happy to accept no SRID)?
>
> Has anyone experienced this problem before? Has anyone used mapserver 
> with
> Oracle 9i w/locator successfully? Any ideas for solving or at least 
> debugging
> my problem?
>
> Thanks,
> Chris Hodgson
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>



--