Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Need help!!!

Need help!!!

From: <siva.thirumaiyan_at_gmail.com>
Date: Tue, 26 Jun 2007 09:03:22 -0700
Message-ID: <1182873802.654691.231570@d30g2000prg.googlegroups.com>


Hi,

Can some one tell me how can I disable a trigger when it is being called?

Please find the details about the setup:

I have create a trigger T1 for the table TAB1 in the schema A in the database D1 and similarly I have create a trigger T2 for the table TAB2 in the schema B in the database D2.

This setup was done inorder to update any transaction that happens locally say TAB1 in the remote database table TAB2.

I have create the procedures to update the transaction in the other database.

However, while testing, I tried to insert/update manually, I am getting the error like primary key constraint voilated.

Hence I disable the trigger at the remote database and tried to update/insert. It worked fine.

There are no problem with delete even when both the triggers are enabled.

Hence in order to automatically disable the trigger in the remote database when it is receiving some updates from the local database. It should get disabled and once the update is done. it should get enabled.

This disabling and enabling should occur only when it is coming from the other database. If anything happens locally, this process should occur. It should go in a normal manner.

Please provide me some solution for this or let me know how to disable the trigger when it is being fired and starts executing the procedures.

Thanks in Advance!!! Received on Tue Jun 26 2007 - 11:03:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US