Hi Guys, I am having a problem with a tabular form.
The query for the form returns approximately 3000 rows which is used for a factory production plan.
When the user modifies any fields in the form, rather than the form submitting those changes to the database, a copy of that dataset is created with a new version number.
I have used the following methodology toget the dataset into a PLSQL procedure which does the background processing and row creations for each new dataset created.
xxmel_pvs_pkg.run_simulator(p_plan => apex_application.g_f01(i)
,p_week => apex_application.g_f04(i)
,p_year => apex_application.g_f03(i)
,p_job => apex_application.g_f06(i)
,p_prod => apex_application.g_f05(i)
,p_model => apex_application.g_f07(i)
,p_qty => apex_application.g_f08(i)
,p_work_unit => apex_application.g_f09(i)
,p_ssd => apex_application.g_f11(i)
,p_run_order => apex_application.g_f17(i)
,p_yield => apex_application.g_f10(i)
,p_sim => v_next_sim_no );
When the dataset is quite small i.e. less than 1000 rows it takes a little of time but still works quite well.
When the dataset is larger i.e. around 3k rows, the page falls over and I am getting the following error (in Firefox v27.0.1)
the connection was reset "The connection to the server was reset while the page was loading.
The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web."
I am getting a similar error with IE9 I am using APEX v4.0.
Any advice would be very appreciated