Search This Blog

Thursday, April 20, 2023

Current version of data in database has changed since user initiated update process. Error occurred in Oracle Apex

Current version of data in database has changed since user initiated update process. 

Error occurred in Oracle Apex



This error can occur for many reasons, but one of the most common reasons is when the same row is updated by multiple parties at the same time. In my case, I get the error when updating a flag in my table. 

Then I realized that when I update the flag a trigger also fires and the same row inside the trigger gets updated again. So I faced a problem.

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;