Is there a Form 10G synchronize built-in replacement?
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