No, the bean timer would not help at all. ItsSorry if I mentioned the bean timer, in this case it would be not very useful.
function is not to refresh anything, but only to act
as a Forms internal timer.
the same code as I've posted at the beginning of this post for the sample form and when
it ran, it just failed with ORA-92102 without refreshing my text item for even once.
I would only commit after the entire process is completed. Committing after each client is processed is inefficient for the database.
Declare Loop_count number := 0; Begin FOR CLT IN FIND_CLIENTS LOOP --:block.item1 := 'Processing client: ' || CLT.CLT_NAME; --synchronize; Loop_count := Loop_count + 1; some_package.perform_something_to_this_client(CLT.CLT_NUMBER); END LOOP; :SYSTEM.MESSAGE_LEVEL := 5; COMMIT_FORM; :SYSTEM.MESSAGE_LEVEL := 0; :block.item1 := 'Processed ' || Loop_count || ' clients'; End;