Frex:
I read through your message and referred to my PL/SQL training. I would recommend against having a trigger that works on both submit and update on BOTH forms which causes data to be pushed between the two forms as you would end up with a continuous loop.
Here is the scenario I recommend:
Push data from table D on new submission to table B. All NEW events occur ONLY in table B with NO flow back to table D.
Same thing for table B to table D.
If you do not do this, you will end up with a looping condition.
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList)
To: [email protected]
Sent: 5/16/2006 12:42 AM
Subject: Re: Transfering data btwn two tables (Oracle server)
** any ideas kind readers?
Frex Popo <[EMAIL PROTECTED]> a écrit :
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
<http://fr.rd.yahoo.com/evt=40577/*http://fr.promotions.yahoo.com/mail/n
ouveaumail.html> et son interface révolutionnaire.
_____
Faites de Yahoo! votre page d'accueil sur le web pour retrouver
directement vos services préférés : vérifiez vos nouveaux mails, lancez
vos recherches et suivez l'actualité en temps réel. Cliquez ici
<http://us.rd.yahoo.com/mail/mail_taglines/yahoofr/*http://fr.yahoo.com/
set> . __20060125_______________________This posting was submitted with
HTML in it___
