Re: Tracking changes

ferraroj wrote:

>I've thought about creating a procedure to create the trigger but if I
>can get away from that idea I would like to.
>
>
>
>At some point in oracle all columns name are translated to a position
>within the record. Are there no hooks down to that level of code. If
>there were I could reference the column by position instead of name.
>
>
>--
>Posted via http://dbforums.com
>
>

I'd like to see someone get this idea just one time without choosing a solution that will bring the database to its knees.

Consider this alternative ... copy of a copy of the original record to a holding table ... and determine the difference after the fact in a report ... if anyone ever cares to check ... they won't.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)