This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jan 3, 2013 5:12 AM by larssjostrom RSS

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

johnwanng Newbie
Currently Being Moderated
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