Has anyone else experienced inconsistent screen freezes when running their forms application?
We are about to go live but our testers are reporting that some of the forms just lock up when they are trying to exit using the X window button.
The forms have a WHEN-WINDOW-CLOSED trigger with the following code:
-- check if window being closed is the main window
-- if so, then exit the form
if :system.event_window = 'WN_MAIN' then
Unfortunately, because the problem is not happening all the time it is very hard to solve. A few observations have been made:
- the problem happens when the application/forms have been on screen for a long time (usually 3+ hours).
- there are usually multiple forms open, but not always.
If anyone else has experienced (and hopefully solved) this problem, please get in touch.
In that form r u using multiple blocks are one block.
If one block try the following code in When-window-closed trigger.
If :system.Record_status = 'Insert' then
The forms are huge, some having as many as 20 blocks and a dozen windows in addition to the main window.
However, I'm going to try your code on some of the smaller forms and perhaps I can enhance it to cope with the larger ones. I'll let you know.
Try this. If you are using multiple blocks.
If :system.record_status = 'insert' and :system.current_block = then
go_block(); -- what block you want to go
I've been trying various methods but to no avail, because the problem is so inconsistent it is difficult to test. However, a colleague at another office has been recieving reports from their customer of the same problem. He contacted Oracle and apparently there is a noted problem and a patch which he is waiting to receive. I will update you when I know more.
Thanks for yor help.