Re: Dynamic trigger

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 15 Mar 2000 07:43:33 -0000
Message-ID: <953106378.16307.1.nnrp-01.9e984b29@news.demon.co.uk>

Try stuffing the old and new values into an array of (column_name, varchar, varchar, type_code) and pass that to a procedure.

The procedure can discover the length of the array when it arrives.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Tracy Wang wrote in message <8amb6d$95k$1_at_news.ml.com>...
>
>Hi all,
>
>Does anyone hear dynamic trigger? I got 34 triggers need to be done as
>almost same functionality, it should keep track the changes on all the
>fields to a log table. basically, I need the trigger to dynamically get all
>the column name of a table, and
>and put the column name, before value, after value of the changes to log
>table. is this possible? let me know. Thanks in advance.
>
>
>tracy
>
>
Received on Wed Mar 15 2000 - 01:43:33 CST