How to Rollback between two different DB in ORACLE?

[spriyasenthil]

Hi all!

Am using two different DB in ORACLE! Letz take it as CONN1 and CONN2 means
DATASOURCE: CONN1
USERID : CONN1
PASSWORD : CONN1
same as CONN2 also!..

In my functions am writing like first opening the connection for CONN1 and doing selection from a table called TABLE1 and closing it and again opening the connection for second connection CONN2 and doing insertion for the same table but in different DB!

Like this am proceeding with so many functions!

I just want to rollback Which is not happening ?? Since it is using two connections!

Can anyone help me regarding this?

Rdgs.
Priya.S.

[pragatiswain]

Hi all!

Am using two different DB in ORACLE! Letz take it as CONN1 and CONN2 means
DATASOURCE: CONN1
USERID : CONN1
PASSWORD : CONN1
same as CONN2 also!..

In my functions am writing like first opening the connection for CONN1 and doing selection from a table called TABLE1 and closing it and again opening the connection for second connection CONN2 and doing insertion for the same table but in different DB!

Like this am proceeding with so many functions!

I just want to rollback Which is not happening ?? Since it is using two connections!

Can anyone help me regarding this?

Rdgs.
Priya.S.

Hi Priya,

Once you close connection to DB, data is commited if autocommit = true.
It will rollback, if autocommit = false.

Why don't you create 2 separate connection object for 2 DBs?
After creating connection object, do begin transaction.
Do all the work. Commit transaction.
Don't close the connections untill all the work is done and you commit.

You have to do this change to all the function.

I hope this helps. Incase of problem mail me : [e-mail]