Re: TRICKY TRIGGER QUESTION

From: Pablo Sanchez <newsrdr_at_mew.corp.sgi.com>
Date: 1997/08/06
Message-ID: <5saoo7$152_at_mew.corp.sgi.com>#1/1


[ clipped oracle newsgroup... ]

In article <870897805.15210_at_dejanews.com>, sprajapa_at_fmrco.com writes:
> Using update trigger, is there any way to capture primary key updates
> into a separate table ? I want to capture all primary key updates in
> a table given as:
>
> log_table
> (table_name char(30),
> old_key_val char(255),
> new_key_val char(255)
> )
>

Perhaps I'm not understanding your question correctly but can't ya just take a look at the deleted table within the trigger? That's the before image...

--
Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p_at_pager.sgi.com
--------------+-----------------+--------------------------------------------
pablo_at_sgi.com ... when mailing me, place "not spam" in the Subject
Received on Wed Aug 06 1997 - 00:00:00 CEST

Original text of this message