I’m trying to configure an Excel Migration Job to act on an API that accepts a single attribute, which is a string of keys.
I wondered if anyone has had any experience in doing this or something similar.
This is the string I get from debug (without the carriage returns) that uses the POSITION_UTIL_API.Modify_Pos method…
p0_ VARCHAR2(32000) :=
'STRUCT_ID'||chr(31)||'16'||chr(30)||
'POS_CODE'||chr(31)||'500042162'||chr(30)||
'VALID_FROM'||chr(31)||'2023-05-22-00.00.00'||chr(30)||
'VALID_TO'||chr(31)||'9999-12-31-00.00.00'||chr(30)||
'OLD_POS_CODE'||chr(31)||'500042318'||chr(30)||
'SUP_POS_CODE'||chr(31)||'500042319'||chr(30);
I’ve tried many variations in Excel like replacing the || with & and double-quoting like “’STRUCT_ID’”.
