Mass Ingestion Applications

Back Next

SAP ODP Source and Oracle Target

The following table identifies the recommended data type mappings for

configurations with an SAP ODP source and an Oracle target:

SAP ODP Source Data Type	Oracle Target Data Type
accp(6)	varchar2(24 char)
char(p), 1 <= p <= 255	varchar2(s char), 4 <= s <= 1020
clnt(p), 1 <= p <= 3	varchar2(s char), 4 <= s <= 12
cuky(p), 1 <= p <= 5	varchar2(s char), 4 <= s <= 20
curr(p,s), 1 <= p <= 38, 0 <= s <= 16	number(p,s), 1 <= p <= 38, 1 <= s <= 16
d16d(p,s), 1 <= p <= 38, 0 <= s <= 16	number(p,s), 1 <= p <= 38, 1 <= s <= 16
d16r	binary_double
d34d(p,s), 1 <= p <= 38, 0 <= s <= 16	number(p,s), 1 <= p <= 38, 1 <= s <= 16
d34r	binary_double
dats	date
dec(p,s), 1 <= p <= 38, 0 <= s <= 16	number(p,s), 1 <= p <= 38, 1 <= s <= 16
fltp	binary_double
int1	number(3)
int2	number(5)
int4	number(10)
int8	number(19)
lang(1)	varchar2(4 char)
lchr *	varchar2(1 char)
lraw *	blob null
numc(p), 1 <= p <= 255	varchar2(s char), 4 <= s <= 1020
quan(p,s), 1 <= p <= 38, 0 <= s <= 16	number(p,s), 1 <= p <= 38, 1 <= s <= 16
raw(p), 1 <= p <= 255	blob null
sstr(p), 1 <= p <= 1333	varchar2(s char), 4 <= s <= 4000
strg *	varchar2(1 char)
tims	timestamp(0)
unit(p), 1 <= p <= 5	varchar2(s char), 4 <= s <= 20
* SAP doesn't specify the maximum length for these data types.