Re: Field names?
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 26 Apr 1999 16:42:16 GMT
Message-ID: <7g2518$2fi$1_at_nntp.csufresno.edu>
Date: 26 Apr 1999 16:42:16 GMT
Message-ID: <7g2518$2fi$1_at_nntp.csufresno.edu>
In article <7g0bg7$3mb$2_at_news.eisa.net.au>,
David Younger <david_at_proware.com.au> wrote:
>In a PL/SQL script, how can I programatically iterate through all the fields
>in a table without specifically knowing the field names?
>
>Specifically, I am trying to write a generic auditing function that will be
>triggerd on insert, update and delete that will be passed the table name and
>will write out all the old/current values of each field.
The DBMS_SQL package would give you some of the functionality you are looking for, but there is no way to do this from within a database trigger, since the pl/sql code to access old and new values cannot be dynamic.
Good luck,
Steve Cosner
Received on Mon Apr 26 1999 - 18:42:16 CEST