V Urgent: Commit across databases.

[hemanr]

Hi Gurus,
I have two instances. Staging and Production.
A change is made in staging and this is inserted /updated in production.
But until a commit is performed in production, I cannot commit it in Staging
How would I check for this and implement it in my stored procedure???

Thanks!!!

[venumadhav]

Take this as the distributed database scenario and use the two phase commit proto. to full fill your data upgradations in production instance.

Thanx
venu

[hemanr]

Hi Venu,
I know that 2 phase commit has to be used but how do I use it???

Thanks