| DATABASE LINK [message #411613] |
Mon, 06 July 2009 01:10  |
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
Hi,
I am using oracle 9i.i am working on two database. one is local and second is remote database . I am using database link to access and alter remote database. My doubt is if I have to do some thing to handle commit or rollback in both database or it is handled by oracle itself. I have studied about two phase commit. Is it implemented by oracle itself or it need some additional resource or configuration.
Regards.
|
|
|
|
|
|
| Re: DATABASE LINK [message #411624 is a reply to message #411615] |
Mon, 06 July 2009 02:09  |
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
Hi,
Thanks for reply. Actually I am firing insert statement in both local and remote database but if I commit in session of local database in which application is running then effects are not commited on remote database. in this case I have problem to rollback if I get some exception in second statement. i am using dynamic query and forms_ddl on form issue these statement
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
