Getting Error uploading imported file.
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
when trying to import/upload an application that was exported from the same workspace. I also tried importing the application in apex.oracle.com and got the same error. The weird thing is that I can import the file just fine via command line. It's just the application builder app that throws this error up.
I think we've all seen this error a million times except this time I do not have access to any apex builder source code so I cannot determine what the problem is. Here are some debug messages from app 4000 page 460 in the app builder:
Exception in "begin wwv_flow_imp_parser.upload_export_file ( p_file => :P460_FILE, p_file_type => :P460_FILE_TYPE, p_security_group_id => :flow_security_group_id, p_file_charset => :P460_FILE_CHARSET, p_flow_user => :flow_user ); end;":
Error Stack: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717 ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425 ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
Exception in "plsql process": Error Stack: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 155 ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2757
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 130
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 468
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC_LOCAL", line 3151
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC", line 4640
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC", line 4678 Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 155
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2757 ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 604
ORA-06512: at "APEX_240200.WWV_FLOW_IMP_PARSER", line 3425
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 130
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 468
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC_LOCAL", line 3151
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC", line 4640
ORA-06512: at "APEX_240200.WWV_FLOW_EXEC", line 4678
ORA-06512: at "APEX_240200.WWV_FLOW_PROCESS_NATIVE", line 34
I think this may be an Apex bug. I am running Apex 24.2.3 on DB version 19.26.0.0.0
I would appreciate any help I can get with this issue. I'm used to importing my apps via the builder so I have a routine that I follow and this “bug” is really disrupting my work flow.
Thanks,
Al