8.3 Data Types for the Location Tracking Server

The PL/SQL subprograms associated with location tracking have parameters of data types that are specific to the location tracking server.

These subprograms are documented in the SDO_TRKR Package (Location Tracking). The specific data types have the following definitions:

• LOCATION_MSG

  (object_id INTEGER, 
   time      TIMESTAMP, 
   x         NUMBER, 
   y         NUMBER) 
  

• LOCATION_MSG_ARR

  VARRAY(1000) of location_msg

• LOCATION_MSG_PKD

  object(arr location_msg_arr)

• NOTIFICATION_MSG

  (object_id INTEGER, 
   region_id INTEGER, 
   time      TIMESTAMP,
   x         NUMBER,
   y         NUMBER,
   state     VARCHAR2(8))
  

• PROC_MSG

  (object_id  INTEGER, 
   time       TIMESTAMP, 
   x          NUMBER, 
   y          NUMBER, 
   region_id  INTEGER,
   alert_when VARCHAR2(2)) 
  

• PROC_MSG_ARR

  VARRAY(1000) of proc_msg

• PROC_MSG_PKD

  object(arr proc_msg_arr)

• TRACKER_MSG

  (object_id INTEGER,
   region_id INTEGER,
   operation VARCHAR2(2))