Updating tables when a view is updated by a dblink

From: <mcampoye_at_yahoo.es>
Date: 21 Feb 2007 10:21:53 -0800
Message-ID: <1172082113.506760.264980@q2g2000cwa.googlegroups.com>

Hi there!
I don`t know if the title of this message is clearly enough... i will try to explain my problem...

I have a dblink to another database. Im my database I have a view (lets call it LocalView) of a table (lets call it RemoteTable) of the remote database.

Then, i also have a table (LocalTable) in my database.

What i want is to update LocalTable when a new row is inserted in RemoteTable. I tried with a INSTEAD-OF trigger in LocalView, but this only work when I insert a row directly in LocalView.

Does anybody have a solution to this?

Thank you very much in advance!!!

P.D: There's no way i can modifiy the remote database. Received on Wed Feb 21 2007 - 12:21:53 CST