1 person found this helpful
I think the mistake is in your select statement
and in my opinion there should be
as you're using it later in the where clause for update. If this does not help, I would suggest to add debug messages into your code like this
begin for i in 1 .. apex_application.g_f01.count loop apex_debug.message('DEBUGMSG: g_f01(%s) = %s', i, apex_application.g_f01(i)); update test12345 set is_useful = 'Y' where prob_id = apex_application.g_f01(i); end loop; --commit; do not commit, apex itself performs either commit or rollback (if there are any errors) end;
run the page in debug mode and then inspect the debug trace to see what's happening under the hood.
Thank You Very Much, Pavel.
Your suggestion worked!