I am probably missing something here, but your connection string looks incomplete to me. I have only seen the following forms:
user/passw...@tns_name user/passw...@database_host:port/global_database_service_name (note the global service name needs to match exactly what the TNS listener on the database host, in particular this is usually not equal to the SID.) Now my confusion is to get the ORA-00942: table or view does not exist error, you must have connected to a database, right? So the next question is did you connect to the right database and as the right user? >>> Paul Ramsey <[email protected]> 03/03/09 5:52 PM >>> You say the query runs OK from SQL/Plus, but are you logging into SQL/Plus as the "sde" user? On Wed, Feb 25, 2009 at 12:33 PM, Balázs Bámer <[email protected]> wrote: > Hi All, > > I have a MapServer 5.2.1 compiled with > ./configure --with-oci > --with-oraclespatial=/usr/local/instantclient_11_1 --with-proj > --with-threads --with-gdal --with-ogr --with-jpeg --with-png=/usr/lib > --with-php=/usr/include/php5 > on Ubuntu 8.10 > > I tried to maka a layer with > > LAYER > NAME lejto > METADATA > "DESCRIPTION" "lejto" > "wms_title" "lejto" > "ows_include_items" "all" > END > PROJECTION > "init=epsg:23700" > END > TYPE POLYGON > STATUS ON > CONNECTIONTYPE oraclespatial > CONNECTION "sde/[email protected]:1521" > DATA "geom from LEJTO_2008_070814 using SRID 23700" > CLASS > NAME "lejto" > STYLE > OUTLINECOLOR 127 127 127 > END > END > DUMP TRUE > TEMPLATE "template.html" > END # layer > > GetCapabilities query works. If I try to draw the map with (you can try): > http://att-it.homelinux.net:22080/cgi-bin/sokfolt?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=lejto&STYLES=&SRS=epsg:23700&BBOX=420000,40000,950000,370000&WIDTH=938&HEIGHT=591&FORMAT=image/png > > > the response is msDrawMap(): Image handling error. Failed to draw > layer named 'lejto'. > msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: > ORA-00942: table or view does not exist > . Query statement: SELECT rownum, geom FROM LEJTO_2008_070814 WHERE > SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, 23700, > NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(420000,40000,950000,370000) > ),'querytype=window') = 'TRUE' . Check your data statement. > > while in sqlplus the query quite similar to the above (just modified > to write row count instead of the 2 columns) > > SELECT count(1) FROM LEJTO_2008_070814 WHERE SDO_FILTER( geom, > MDSYS.SDO_GEOMETRY(2003, 23700, > NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(420000,40000,950000,370000) > ),'querytype=window') = 'TRUE' > > runs. > > SRID information and table user_sdo_geom_metadata is actualized: > > Insert into USER_SDO_GEOM_METADATA > (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) values > ('lejto_2008_070814','GEOM',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',437534.249899998,935741,5E-8),MDSYS.SDO_DIM_ELEMENT('Y',47058.0469,355027,5E-8)),23700); > drop index IDX_LEJTO_2008_070814_GEOM; > UPDATE lejto_2008_070814 c SET c.geom.SDO_SRID=23700; > CREATE INDEX idx_lejto_2008_070814_GEOM ON lejto_2008_070814 (GEOM) > INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('layer_gtype=POLYGON'); > > What can be the problem? > > Thank you in advance. > Best regards: Balázs Bámer > > What can be the problem? > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
