Re: Autonomous transactions

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Fri, 19 Apr 2002 18:56:29 GMT
Message-ID: <3CC06852.8524B85B@exesolutions.com>

You are in a world of hurt here. I think Tom Kyte may have posted a workaround on his site some time back but I can't find it right now.

My suggestion would be to upgrade the client to 8i if they can't upgrade to 9i.

Daniel Morgan

anorfri wrote:

> Hi !!!
>
> First of all, sorry for my bad english !!!
>
> I have a problem with an application that i should port from 8i to 8.0.4.
> This application have some triggers, and uses the pragma
> AUTONOMOUS_TRANSACTIONS to isolate transactions made by some procedures
> called from it. The problem is that 8.0.4 do not support autonomous
> transactions, or at least don't understand this pragma when i complile the
> procedure.
>
> Does anyone know a solution? (apart from upgrade to 9i, which is not
> possible now to the client)
>
> Thanks !!!
>
> Anorfri
Received on Fri Apr 19 2002 - 13:56:29 CDT