Re: How to handle the exception when remote db is down

Thomas and Nick, Thanks for your responses.

AQ is to propagate messages to and from non-Oracle messaging systems. Here I just interact with another oracle database thru distributed transaction. Why do I need AQ in this place?

On Wed, 16 Feb 2005 08:37:23 -0500, Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> wrote:
> Sami,
>
> The problem is that Oracle is still holding the update to the remote
> database open. Try the following:
>
> You could also look at using savepoints. Nick had a good idea also about
> looking at Advanced Queueing.
>
> Tom
>
>
> -----Original Message-----
> Hi All,
>
> I am trying to do DML activity on both local and remore DB. If the
> remote db is down, I need to insert the values into temporary table on
> the local db so that later when the remore db becomes available I can
> push the records.
>
>

--
http://www.freelists.org/webpage/oracle-l