oracle spatial

[Fernando Simon]

Hi folks,
    The native Oracle Spatial connection work without problems with
different file formats as Jukka told. Daniel, can you sen your full Mapfile?
    I never worked MS4W but you can try to test your Mapfile directly
using a CGI Mapserver. Can you put the Oracle layers in the end of the
Mapfile? Can you define just one layer in your mapfile an test it? And
after this you can add the layers to this new Mapfile to test all in the
same file. You can use the DEBUG flags to force Mapaserver to report
step by step in the Apache log.
    Here I use the Oracle Spatial Client with OCI, Apache 2.2.2 and PHP
5.1.4 and Mapserver 4.8.3 without problems.
    Best regards and sorry for the delay to reply.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


Rahkonen Jukka wrote:
>  
> Hi,
>
> MS4W 1.5.3 with native Oracle support is totally functional with different file formats. I have in a same mapfile layers from local GeoTIFF and JPEG 2000 images, external rasters through WMS service, local shapefiles, polygons from Oracle spatial and external vectors through WFS service and they work just fine, all together.
>
> I wonder why you get problems with other that Oracle spatial layers after changing the libmap.dll and activating the ogr_OCI.dll. They should have no effect on those layers, but if they do then I believe it is no use to struggle with other things before that problem is solved.
>
> -Jukka-
>
>
> -----Alkuperäinen viesti-----
> Lähettäjä: Daniel Goetz [mailto:madprof at gmx.ch] 
> Lähetetty: 14. kesäkuuta 2006 14:02
> Vastaanottaja: Rahkonen Jukka; MAPSERVER-USERS at LISTS.UMN.EDU
> Aihe: Re: Re: [UMN_MAPSERVER-USERS] oracle spatial
>
> Hi Jukka,
>
> thank you again for your help. You think it should be possible to map differnt file-formats (shapefiles, oracle spatial, raster-data, etc.) at the same time even if you have changed the .dll files for orcale support?
>
> The suggestions you made in your e-mail, that I should test a new, "untouched" installation of ms4w on another computer, i have already tested. I installed ms4w, tested some shapfiles and raster data and they worked. then I did the .dll swapping and neither the oracledata nor other file-formats work. I always get an apache-error-message. except for I point to a table that does not exist in the database in the DATA-experssion of the mapfile. then I get the mapserver-error-message you mentioned in your last email. 
>
> And yes, I testes the unsuccessful SQL (correcting the consciously wrong tablename_experssion) and it workes fine. Perhaps you can email me your mapfile, in which you point to an oracle spatial database. Perhaps I do a mistake in the mypfile. Would be very nice. Thank you for your endeavor and your time and your help.
>
> regards
>
>
> .......
>
> SNIP
>
>