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
Previous Topic: TNS Error when using DB link
Next Topic: Add rule to oracle connection manager
Goto Forum:
  


Current Time: Tue Sep 30 15:13:56 CDT 2014

Total time taken to generate the page: 0.10590 seconds