[mapserver-users] Oracle database problem

[Balázs Bámer]

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/asdfgh at 10.0.8.51: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?