Dear List,
I wrote the following bit of code yesterday to cause a
process to kick off at a particular time. This was not
doable via DBMS_JOB, as the code that follows this bit
is a sqlplus script from an app vendor.
When I ran this last night, I expected it to sleep til 20:00.
Instead, it slept for about 45 minutes.
Here's an example from this morning that should have slept
until 10:00 AM, but instead only slept 25 minutes.
Any ideas? Did I code something wrong here?
This is 8.1.6.3 on Windows NT 4 SP 6.
Just change the '10' below to some hour > sysdate
Thanks,
Jared
===================================================================
declare
seconds integer;
begin
-- seconds from now til 10:00 AM
select (to_date(trunc(sysdate)+(10/24)) - sysdate ) * ( 24*60*60)
into seconds
from dual;
dbms_output.put_line(seconds);
dbms_lock.sleep(seconds);
end;
09:10:15 RSYS13 - agile@orcl SQL> /
2681
PL/SQL procedure successfully completed.
09:36:05 RSYS13 - agile@orcl SQL> select 2861/3600 from dual;
2861/3600
----------
.794722222
1 row selected.
14:13:02 RSYS13 - agile@orcl SQL>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
