can you tell me what is a function similar as dbms_lock.sleep exict from Oracle 9i.
because i want take more exactly time in fraction of second.
and dbms_lock.sleep(second in NUMBER), but i know that similar function exists from Oracle 9i but there time in INTERVAL.
please help me, what is the name of that function?
I've never heard of such a fuunction, that's not to say it doesn't exist.
The other thing to remember is that it is rare to any sleep operation to be totally accurate because of the delays associated with calling a procedure, setting a timer of some description, noticing the time is right to wake up and then actually waking up the process.
As such I doubt you will every get an accurate short duration pause in a language such as PL/SQL.
It's only my opinion, but I'm happy to be proved wrong.