Deleted Process still working in Background APEX 24.1.4?
Posted: Mon Dec 02, 2024 2:10 pm
If you are using Oracle APEX with Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production Version 23.6.0.24.11 then if you deleted a process in a page and created new but still that delete process code will be working in the background. This issue noticed in APEX 24.1.4 in the cloud instance may be resolved in the later versions but in cloud still it is this version. To resolve this you need to login as sys from the landing page and then execute following code,
BEGIN
DBMS_RESULT_CACHE.FLUSH;
END;
BEGIN
DBMS_RESULT_CACHE.FLUSH;
END;