SEO

#1 (**permalink**) 02-24-2008, 06:07 AM

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

#2 (**permalink**) 02-24-2008, 06:08 AM

On 21 Jul 2004 07:00:41 -0700, bozzie@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

#3 (**permalink**) 02-24-2008, 06:08 AM

bozzie@xs4all.nl (Peter Leijsten) wrote in message news:<2b39ddad.0407210600.2b40207b@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

#4 (**permalink**) 02-24-2008, 06:08 AM

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

Thx Sybrand, and David as well. Keeping my job won't be a problem;-).
We just want to try some stuff in the exception handler, that's all

Thanks again.

kind regards,
Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

fabricating a ORA-02049 message