LAYER
  NAME popplace # ORACLE
  METADATA
    "DESCRIPTION"  "Cities"
    "TEST"          "TESTING"
#    "RESULT_FIELDS" "NAME"
    "wms_title"    "popplace"
  END
  LABELCACHE TRUE
  TYPE POINT
  status off
  CONNECTIONTYPE oraclespatial
  CONNECTION 'user/pass@192.168.4.16/SID'
  PROCESSING "CLOSE_CONNECTION=DEFER"
  DEBUG 5
  DATA "ORA_GEOMETRY FROM popplace_view USING  SRID 4326"
  TEMPLATE "ttt_query.html"
  LabelItem "Name"
#  CLASSITEM "Capital"
  CLASS
    EXPRESSION /1/
    STYLE
     SYMBOL gif
     SIZE 100
     COLOR 0 255 25
    END
   LABEL
     COLOR 255 255 255
     FONT sans
     ANGLE 0
     TYPE truetype
     SIZE 8
     OUTLINECOLOR 255 255 255
    END
     METADATA
      "TEST" "One two"
     END
    NAME "Cities"
    LABEL
      COLOR  255 0 25
      FONT sans-italic
      TYPE truetype
      SIZE 10
      POSITION AUTO
      PARTIALS FALSE
      OUTLINECOLOR 255 255 255
    END
    COLOR 0 255 25
  END
  CLASS
    EXPRESSION /2|3/
    TEMPLATE "ttt_query.html"
    NAME "Cities"
    LABEL
     COLOR 255 0 255
     FONT "sans"
     TYPE truetype
     PRIORITY 2
     SIZE 12
     POSITION AUTO
     PARTIALS FALSE
     OUTLINECOLOR 255 255 255
    END
   STYLE
    SYMBOL test1
    SIZE 12
    COLOR 255 3 200
   END
   END
   TOLERANCE 5
 END # Layer

#################

LAYER
   NAME road
   METADATA
     "DESCRIPTION" "Roads"
     "wms_title"    "roads"
   END
   DEBUG 5
   TYPE LINE
   STATUS DEFAULT
  TEMPLATE "ttt_query.html"
  dump true
   CONNECTIONTYPE oraclespatial
  CONNECTION 'user/pass@192.168.4.16/SID'
#    PROCESSING "CLOSE_CONNECTION=NORMAL"
   DATA "ORA_GEOMETRY from road2"
   CLASS
   NAME 'crash it'
   COLOR 255 80 80
END