OK, so my code is too complex. :) Do you know why dbms_lock.sleep doesn' twork?
Jared On Thursday 31 October 2002 15:04, Khedr, Waleed wrote: > Hi Jared, > > You do not need the "to_date" function, just: > > select (trunc(sysdate)+(10/24) - sysdate ) * ( 24*60*60) into seconds from > dual; > > Regards, > > Waleed > > -----Original Message----- > Sent: Thursday, October 31, 2002 5:35 PM > To: Multiple recipients of list ORACLE-L > > > 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: Jared Still 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).
