PL/SQL timing problem

Hi guys,

     I want to get the elapsed time during the loop, once it is added up to 4 seconds I will exit the loop and give a timeout error.

     I am using mod(DBMS_UTILITY.get_time,100), but it seems that it was set to 0
once it gets 100(which is 1 second). I want accumulative time(default is 0) that is spend during
the loop. is there any nice idea about this?          

Thanks so much for any help:) Received on Tue Nov 28 2006 - 08:13:17 CST