Re: SLEEP Procs

DA Morgan wrote:
> Jonathan Lewis wrote:

>>
>> Did you check for the "long" sleep problem that the
>> FAQ describes.

Here are the first two results:

SQL> DECLARE
   2 stime TIMESTAMP(9);
   3 etime TIMESTAMP(9);
   4 BEGIN
   5 stime := SYSTIMESTAMP;
   6 dbms_backup_restore.sleep(2100);    7 etime := SYSTIMESTAMP;
   8 dbms_output.put_line(etime-stime);    9 END;
  10 /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
+000000000 00:35:00.000000000

PL/SQL procedure successfully completed.

SQL> select 2100/60 from dual;

    2100/60

         35

SQL> DECLARE
   2 stime TIMESTAMP(9);
   3 etime TIMESTAMP(9);
   4 BEGIN
   5 stime := SYSTIMESTAMP;
   6 dbms_drs.sleep(2100);
   7 etime := SYSTIMESTAMP;
   8 dbms_output.put_line(etime-stime);    9 END;
  10 /
+000000000 00:35:00.000000000

PL/SQL procedure successfully completed.

SQL> So far so good.

-- 
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