Home » RDBMS Server » Networking and Gateways » Method of Heterogeneous of Communication between Oracle to SQL Server. (10g (10.2.0.5) on windows 2008 R2 and SQL server on windows 2008 R2)
Method of Heterogeneous of Communication between Oracle to SQL Server. [message #609767] Wed, 12 March 2014 02:29
arhaan
Messages: 5
Registered: March 2014
Location: MALAYSIA
Junior Member
Dear friends,


i trying to make insert into Tables of SQL Server with some update data on XXX Table in Oracle DB

but as know we want to make one commit @ end of transaction to be sure all are successfully and no errors


but unfortunately it asks me to make commit. for each row

so we will get partial Record and not complete and we will find missing information.

kindly let me know what would be the solution for commit at the end;

waitting for your feed back....

thanks in advance

Report message to a moderator

Previous Topic: TNS Error when using DB link
Next Topic: Add rule to oracle connection manager
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 01:54:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.