Re: TRICKY TRIGGER QUESTION

[ 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