Jasbinder Singh Bali wrote:
What if its just SLEEP for 1 second. Why would it keep my stored procedure hanging ?
Because presumably your loop-condition isn't under your control (otherwise you wouldn't need to sleep).
Can you *always* guarantee the condition (a=b) will happen within a reasonable time-frame?
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
