function or procedure for delay a process.
Hello, i4m looking for a function or procedure that delays the normal flow of a pl/sql block, i want something like "wait(n)" and the process stop for n seconds, after that re-start in the place it stopped.
e.g
begin
wait(10); --Here, the process stops for ten seconds, after that time, the process
--executes next statement;
dbms_output.put_line('after waiting');
end;
It would be good too, a recursive function that executes itself after a number of
seconds;
Thanks in advance.