Re: fabricating a ORA-02049 message

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 21 Jul 2004 20:24:51 +0200
Message-ID: <26dtf0p0ajo593ghdfd5f7qluhvgaarfbp@4ax.com>

On 21 Jul 2004 07:00:41 -0700, bozzie_at_xs4all.nl (Peter Leijsten) wrote:

>Believe it or not, for analyzing some problem at work my boss actually
>wants me to to write a script that will generate a ORA-02049
>(time-out: distributed transaction waiting for lock) message. From
>searching in the archives of this newsgroup I believe it has something
>to do with accessing tables at remote databases and the
>DISTRIBUTED_LOCK_TIMEOUT parameter. Is there an easy way to 'generate'
>this oracle error message using a two databases connected via a
>database link?
>
>thanks in advance,
>Peter Leijsten

raise_application_error(-20409) in any procedure will do. What problem are you trying to resolve other than to keep your job.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jul 21 2004 - 13:24:51 CDT