Oracle does not have a LOGICAL data type. You can change the data type for a field from DECIMAL to LOGICAL in the schema holder. OpenEdge then reads the numeric values stored in the Oracle column, as the following table shows.

Table 1. LOGICAL data type and Oracle equivalents
OpenEdge Oracle
True Any nonzero value
False 0

The DataServer stores the contents of an OpenEdge LOGICAL data type in an Oracle NUMBER column as:

  • True = 1
  • False = 0

If you retain values other than 1 or 0 in the Oracle column, do not write a value to that column as a LOGICAL data type.