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’”.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.