dbms_lock.sleep()

From: <PRIBILLA.Michael_at_EU.DRAGOCO.COM>
Date: Mon, 22 May 2000 13:19:17 +0200
Message-Id: <10505.106212@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFC3DF.917814B4
Content-Type: text/plain;

charset="iso-8859-1"

DBAs,

is there any known - negative - side effect when using the above procedure in Oracle 7.x/8.x stored procedures?

I would like to use this procedure in an interface scenario where the interface procedures are called in short intervals of 5 to 20 seconds.

I already implemented this in the test environments without problems but I just want to make sure there is no potential risk. Any comment is wellcome.

TIA,
Michael

------_=_NextPart_001_01BFC3DF.917814B4
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>dbms_lock.sleep()</TITLE>
</HEAD>
<BODY>

DBAs,


is there any known - negative - side =
effect when using the above procedure in Oracle 7.x/8.x stored = procedures?


I would like to use this procedure in =
an interface scenario where the interface procedures are called in = short intervals of 5 to 20 seconds.

I already implemented this in the test =
environments without problems but I just want to make sure there is no = potential risk.

Any comment is wellcome.


TIA,
 Michael

 
Received on Mon May 22 2000 - 06:19:17 CDT