This discussion is archived
3 Replies Latest reply: Nov 16, 2012 10:51 PM by Mehabub Sheikh RSS

4.2 - Data Loading Page Type

Mehabub Sheikh Journeyer
Currently Being Moderated
Hi,

I had created pages using data load page wizard. I had put transformation rules SQL Query returning single value. I could see that it has transformed the data as per my rules.
When I run that with CSV, I could see that it has transformed the data as per my rules. But after clicking load data button file I am getting data upload failed error.
I enabled debug and following is the error message from accept phase

......error_backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_DATA_UPLOAD", line 3112 ORA-06512: at "APEX_040200.WWV_FLOW_DATA_UPLOAD", line 3813 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 213 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 262 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1808 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 452

Also I could see from error tabs in the debug page
Data Loading Failed ORA-00040: active time limit exceeded - call aborted

Could you please help?

Thanks,
Mehabub

Edited by: Mehabub Sheikh on Sep 5, 2012 3:14 AM

Edited by: Mehabub Sheikh on Sep 5, 2012 6:27 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points