Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make Forms wait for 5 minutes

Re: How to make Forms wait for 5 minutes

From: Michael Pelzelmeyer <mikepelz_at_netway.at>
Date: 1998/02/16
Message-ID: <34E82A7F.1168@netway.at>#1/1

Hi,
take a look at the dbms_lock package. There is a sleep procedure. DBMSLOCK.SQL
HTH
Michael

Ranga Raghunathan wrote:
>
> Hello,
> When the Database connectivity is lost during the application startup, I
> want Forms to wait for 5 minutes before it tries to reconnect again. I have
> the following procedure called, when the database connectivity is lost.
> Procedure RETRY_PR
> l_start_time date := to_date (:system.current_datetime);
> l_curr_time date;
> l_retry_time integer;
> BEGIN
> l_retry_time := :parameter.retry_min * 60; -- retry_min is passed as a
> parameter into the Form and will be 5 (minutes).
> l_curr_time := l_start_time;
> LOOP
> IF 24*60*60 * (l_curr_time - l_start_time) >= l_retry_time THEN
> EXIT;
> END IF;
> l_curr_time := to_date (:system.current_datetime);
> END LOOP;
> END;
> This code hangs my application. When I add a message statement inside the
> loop along with PAUSE, the logic works fine. I do not know what causes Forms
> to hang the application. Can anybody help me with this ?
> Thanks
> Ranga.
  Received on Mon Feb 16 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US