DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Inconsistent Screen freeze when exit form

  1. #1
    Join Date
    Nov 2000
    Posts
    3
    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.


  2. #2
    Join Date
    Aug 2000
    Posts
    53
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    3
    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.


  4. #4
    Join Date
    Aug 2000
    Posts
    53
    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

  5. #5
    Join Date
    Nov 2000
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width