January 21, 2010 at 5:15 pm
I am doing an BEGIN TRANSACTION in Stored Procedure in SQL 2005
I am using an OPEN QUERY Call to an ORACLE Stored Procedure thru a Linked Server using MSDAORA OLEDB Driver
Functions work fine.
when attemting a ROLLBACK it is not rolling back on the ORACLE side
CAN YOU HELP?
January 22, 2010 at 2:56 am
Check the settings on the Oracle side: is it configured for two-phase commit? I think this is an option on the provider.
-- Gianluca Sartori
January 22, 2010 at 6:30 am
again? how many times are you planning to post the same question in different sections?
You have to use BEGIN DISTRIBUTED TRANSACTION - check BOL for details.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply