Flush memory in Loop
634283Apr 17 2008 — edited Apr 17 2008I am trying to flush the memory in between the loop. But I am getting an error while doing so. pls suggest. I am using 10g. Here is the code:
BEGIN
for c2 in (select seq, function_name from REP_FUNC_LIST order by seq)
loop
dbms_output.put_line('Seq_Number - '||c2.seq||'; Function - '||c2.function_name);
EXECUTE IMMEDIATE 'BEGIN '||c2.function_name||'.START_PROCESS;'||' END;';
ALTER SYSTEM FLUSH BUFFER_CACHE;
end loop;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('ERROR') ;
END;