Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r092

...

Info

NOTE: Implementation of Oracle custom types is a custom engagement. For more information, please contact

D s proserv
.


Write/Publish

D s item
itemData Type

Oracle Column TypeNotes
BoolVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
IntegerINT

INTEGER

SMALLINT

DECIMAL

DEC

NUMERIC

NUMBER

FLOAT

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
StringVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
DatetimeTIMESTAMP

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
TimestampVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
FloatDECIMAL(38,9)Oracle DECIMAL column type must include the scale (total number of permitted digits) and precision (total number of digits permitted to the right of the decimal) as parameters.

DEC

NUMERIC

NUMBER

FLOAT

VARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
MapVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
ArrayVARCHAR(256)Oracle VARCHAR column type must include the maximum number of permitted characters.
Info

NOTE: If you are appending to an existing table where a column's

D s item
itemdata type
is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.

...