Skip to content

Error: ORA-00932 with Oracle and mapserver 8.6 build from 27.4.2026 #7489

Description

@DanielKnoop

I encountered an error with mapserver and oracle after updating from mapserver 8.6 build from 29.1.2026 to mapserver 8.6 build from 27.4.2026.
I use the stable build (daily) from gisinternals.com

I think it has to do with this issue: #7463
(but I'm not sure, there is a second commit to oraclespatial.c in the timerange)

the original query from mapserver to the database was:
SELECT "ART", "LEITUNGSART", "STATUS", FID,rownum, GEOM FROM (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'

after the update, the error logged is:

[Tue Apr 28 13:11:22 2026].628000 Error: ORA-00932: Inkonsistente Datentypen: %s erwartet, %s erhalten
. Query statement: SELECT btmp.*, ROWNUM FROM (SELECT "ART", "LEITUNGSART", "STATUS", FID,GEOM FROM (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' ) btmp  . Check your data statement.msOracleSpatialLayerWhichShapes()
[Tue Apr 28 13:11:22 2026].628000 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data statement and server logs

btmp was introduced with the issue i mentioned.

the layer definition (i.e.) is as followed:

  LAYER
    NAME "FW_STRANG"
    STATUS ON
    METADATA
      "wms_title" "Strang"
      "wms_layer_group" "/leitung"
      "wms_group_title" "Leitung"
    END
    TYPE LINE
    CONNECTIONTYPE PLUGIN
    PLUGIN "oracle"
    CONNECTION "WAERME/XXX@tnsname"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    DATA "GEOM from (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) USING UNIQUE FID SRID 25832"
    EXTENT 366712 5906795 401562 5921118
    MINSCALEDENOM 50
    #MAXSCALEDENOM 5000
    SIZEUNITS METERS
    CLASS
      NAME "Vorlauf Anschlussltg Planung"
      #Display Model Expression ART = 1 AND  LEITUNGSART  =  2  AND  STATUS  =  3
      EXPRESSION ((([ART] = 1) AND ([LEITUNGSART] = 2)) AND ([STATUS] = 3))
      MINSCALEDENOM 50
      MAXSCALEDENOM 5000
      STYLE
        WIDTH 0.12
        COLOR "#FF00FFFF"
        LINECAP ROUND
        LINEJOIN MITER
        PATTERN
          0 0.24 0.12 0.24 0 0.24 0
        END
      END
    END

... many classes more ...

  END

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions