Re: Need help!!!

siva.thirumaiyan_at_gmail.com wrote:
> Hi,
>
> Can some one tell me how can I disable a trigger when it is being
> called?

Triggers are not 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.

Your boss should fire you for wasting time and money re-inventing the wheel. Go to http://tahiti.oracle.com and look up "Streams" and "Change Data Capture."

And your wheel isn't even round.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org