Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> get_time decrementing...?!
Does anyone have any idea what could cause an elapsed time, calculated
with two calls to dbms_utility.get_time, to come out as negative?
I have a check constraint, stating that numbers inserted into an
elapsed_time column must be >=0, that is being violated.
This error is sporadic, but worrysome. Any assistance would be most
appreciated.
As a corollary, can anyone provide any information on exactly what
this "arbitrary point in time" that the get_time clock starts from?
What causes this clock to reset?
Thanks,
Mark
Technical Consultant
LHS InfoCell
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 22 1999 - 09:51:03 CDT