APEX

Hi,

I recently built an APEX app to allow users to maintain data in a custom table and used the app from this link as a starting point. This link has been provided in multiple threads in these forums.

http://htmldb.oracle.com/pls/otn/wwv_flow_custom_auth_std.login_page?p_flow_page=38131:1:1287783765705596

Basically, the app allows the user to Browse thier PC for the file and upload it. When they choose Upload, a package parses the file and displays it as a report on the page so they can review and see the file has parsed correctly. At that point, they can choose to Process the file. I added a radio group to allow the users to choose to Add, Update and completely Reload the table.

Everything works great with smaller files but when I try larger files, I seem to be having some "time out" issues with the app/browser. The custom table currently has 45,000 records. When I first tried a full reload, the browser session ran for 2 hours before I finally killed it. So I tried 10,000 records and everything worked fine. It ran a few minutes, but did return my 'File processed successfully' message. I bumped the record count up to 25,000. After a few minutes of processing, I realized it actually does complete the update by looking in the table at the data, but the APEX app/browser session stays in a running state and never returns the success message.

My question is, what could be the issue in the app session that makes it not return the success message after a large file is processed? Are there repagination or session settings in the app that could be causing the issue? I'm pretty new to APEX, so I'm not sure what to look at in the default settings for some of these areas in the app.

Any help would be much appeciated.

Thanks,
Troy