Inconsistent Screen freeze when exit form

[savant1]

Hi,

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
exit_form;
end if;

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.

Thanks,
Clare.

[abc]

Hi savant1.
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
commit;
else
Exit_form(no_commit);
end if;

Thanks
ABC

[savant1]

Thanks abc,

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.

[abc]

Hi savant1.
Try this. If you are using multiple blocks.

If :system.record_status = 'insert' and :system.current_block = <block name> then
commit;
go_block(<block name>); -- what block you want to go
else
go_block(<block name>;
end if;

Thanks
ABC

[savant1]

Hi ABC,

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.