Burst of memory - Oracle x Workflow
Oi, I am having a problem, I call procedure wf_notification.respond and this flame wf_engine_util.complete_activity that he is in an infinite Loop calling the packages wf_item_activity_status and wf_engine. It seems that the part that is causing the Loop is this:
-- For loop to get all the next transition activities.
-- This is to avoid maximum open cursor problem.
for child in children(actid, lresult) loop
childarr(i) := child.to_process_activity;
i := i+1;
end loop;
E as it is in an infinite Loop is giving to a relative error the memory. It follows below the error that was catches of alert.log.
Errors in file /products/oracle/admin/satc/udump/satc_ora_5414.trc:
ORA-07445: exceção encontrada: dump de memória [qmxIterInit()+24] [SIGSEGV] [Address not mapped to object] [0x8] [] []
Somebody has some idea? The version of workflow is the 2.6.0.1.5, Oracle 9.2.0.1, SO RedHat 9