1 2 Previous Next 21 Replies Latest reply: Jan 3, 2013 7:12 AM by Lars Sjöström RSS

    Is there a Form 10G synchronize built-in replacement?

    johnwanng
      Hi everyone,

      I've converted some old Oracle 4.5 Form to 10G Form and I'm currently testing them one by one. I noticed that for those forms that were using the 'synchronize' commands to refresh text_item are no longer working. Not only their items were not refreshed but the forms have also thrown out the 'ORA-92102:Network Error'. Here is a snapshot of the code in 10G Form:

      --- BEGIN ---

      CURSOR FIND_CLIENTS IS
      SELECT C.CLT_NUMBER, C.CLT_NAME CLT_NAME
      FROM ALL_CLIENTS C
      ORDER BY C.CLT_NAME;

      BEGIN
      FOR CLT IN FIND_CLIENTS LOOP
      :block.item := 'Processing client: ' || CLT.CLT_NAME;
      synchronize;          
      END LOOP;
      END;

      --- END ---

      I've discovered that every execution of the 'synchronize' command will perform a network trip between the web server and the web form client and Oracle strongely discourages the use of it but it does not suggest any alternatives. Is there a solution to it? Thank you for your time and assistance.

      Regards,
      John
        1 2 Previous Next