Re: Trigger cursor interrogation

Oracle Version 9.2.0.1.0 (Linux)

Thanks for the response (also Sybrand)

We have a browser based workflow application that lets the user customise the on-screen forms by adding new elements. These are then added to the database with 'alter table add column'. So for any form there are fixed elements in a fixed table that are known and user added elements in a key linked child table which are unknown. For arguments sake lets call them:

   emp: fixed elements
   emp_extra user added elements

We have an auditing procedure called from a row level trigger that does high-level auditing of database activity on the _extra table. It must compare each of the :old and :new elements and note discrepencies.

Now getting the list of column names is easy, just query USER_TAB_COLUMNS, but how do you access the column value using :new and :old with a variable column name?

DA Morgan wrote:
> Paul Byrne wrote:
>

>> Hi,
>> I need to get the values for all of the :new and :old trigger columns 
>> when the columns on the table are user defined. Since I don't know 
>> what the columns on the table are going to be I can't hard code values 
>> in the normal way. Does anyone know of a dynamic way of doing this?
>>
>> Thanks,
>> Paul