Dear all,
I am in the process of helping a colleague write some PL SQL. I am not hot in PL SQL but I guess it shouldn´t be that different from Sybase Transact SQL.
We have two Oracle Database sitting on different Unix servers. We would like to push data from one table in one database so that users on the other Database can see the data as well.
Database A has Table A and Table B (Temp Table)
Database B has Table C and Table D (Temp Table)
Data from Table A is pushed automatically to Table B through some SQL routine.
Data from Table C is also pushed automatically to table B through some SQL routine.
I need to write some PL SQL to push data from table B across to table D and vice versa.
There will be tuples created as well as updated on both tables B and D and any inserts or updates should be sent both ways.
I was thinking about creating two triggers one for insert and the other for an update on table B and the same on Table D so that data created on table B will be sent in real time to table D and vice versa.
Within the same triger (insert for example) I need to push the data and mark the tuple as being transfered. I tried this one on a simple table and got an error which states that table is mutating so I discovered that this is due to the entry being locked as I am using an after trigger for row level...
Any thoughts on how to tackle this issue and write some clean code will be very much appreciated.
Regards
Frex
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. __20060125_______________________This posting was submitted with HTML in it___
