Re: PL/SQL timing problem

Jun wrote:
> 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:)

You still haven't stated a business case and I still think the idea is bad in concept and architecture. Look at DBMS_ALERT ... look at Advanced Queuing ... or look at the solution proposed by Stephen O'D (though I'd prefer coding it as a WHILE loop).

Without the business requirement it still doesn't make sense.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org