Re: fabricating a ORA-02049 message

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 21 Jul 2004 11:47:26 -0700
Message-ID: <9711ade0.0407211047.bb87033@posting.google.com>

bozzie_at_xs4all.nl (Peter Leijsten) wrote in message news:<2b39ddad.0407210600.2b40207b_at_posting.google.com>...
> 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

declare

	tst_wait exception;
	pragma exception_init(tst_wait, -2049);
begin
	raise tst_wait;

end;
/

SQL> @2049
declare
*
ERROR at line 1:
ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at line 5

Easy as that.

David Fitzjarrell Received on Wed Jul 21 2004 - 13:47:26 CDT