hi as stated above, thanks for any help
No meaningful error is being logged, I've added an error log table per the docs into the definition and nothing is going in. Even with debugging on nothing is showing up. Appreciate any steer to see where the problem lies.
XLS loader is two character fields going to two varchar2 fields in the database , nothing more, I've cut it right back to firstname/lastname and still get the error. Here's the debug stack - 6502 isnt much of a clue. If it was the data I'd expect an error to be chucked in the table. The XLS opens fine in Excel.
Error: ORA-06502: PL/SQL: value or conversion error: associative array key violates its type constraints -
Additional info: ORA-06502: PL/SQL: value or conversion error: associative array key violates its type constraints -
Display location: INLINE_IN_NOTIFICATION - Association type: - Item name: - Region id: - Column alias: - Row: - Model instance id: - Model record id: - Internal error: false - Common runtime error: false - APEX error code: - SQL code: -6502 - SQL error: ORA-06502: PL/SQL: value or conversion error: associative array key violates its type constraints ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1323 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1055 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 952 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 952 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 1515 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 866 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1263 ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1472 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634 - Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1323 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1055 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 952 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 952 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_PROFILE", line 1515 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 866 ORA-06512: at "APEX_230200.WWV_FLOW_DATA_LOADING", line 1263 ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1472 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634 ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 192 - Statement: - Component: APEX_APPLICATION_PAGE_PROCESS Load Data (5354325753532585)
If this is something to do with trimming blanks can you please add documentation to show how to use transformation rules - there's nothing in the 23.2 docs to show how to use ltrim/rtrim or whatever