Re: Trick to update 2 tables in the same view?

From: John Russell <johnrussell10_at_home.com>
Date: Thu, 25 Jan 2001 22:32:57 GMT
Message-ID: <3a70a8ef.306631323@news>

On Thu, 25 Jan 2001 11:36:10 +0100, "Tony" <micronet_at_chello.nl> wrote:

>Is there a trick to update 2 tables in the same view ?
>
>Without triggering the
>"ORA-01779: cannot modify a column which maps to a non key-preserved table"
>
>Something in PL/SQL perhaps?

You need to use an INSTEAD OF trigger, where the trigger figures out the relevant DML and issues those statements. For examples, see:

http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?word=instead+of+trigger&book=&preference=Examples&expand_all=1

John Received on Thu Jan 25 2001 - 16:32:57 CST