DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: oracle trigger

  1. #1
    Chris Savage Guest

    oracle trigger

    I need to write a procedure which will be called by triggers placed on
    hundreds of different tables to carry out logging of changes. The process
    involved is identical for all tables so a common procedure working with
    passed parameters would seem the most maintainable. The problem I have is
    that the table name and field name are recorded on the log.

    Is the table name available to the trigger placed on a table? I know I could
    "hard-code" the table name in the trigger but I would rather pick it up.

    Is the field name available - I know OLD and NEW values for the field data
    are available but I need the field name too.

    I'm new to PL/SQL coding so if the answer is obvious then please don't

    Chris Savage

  2. #2
    bhargav Guest

    Re: oracle trigger


    the maintenance of triggers is looked after by the databse. there is a
    table USER_TRIGGERS in which all the user defined triggers will be there.
    while defining the trigger, you specify the values of trigger, like when
    do let it fired and on which table it to be fired and is it table level trigger
    or row level trigger. in that table all these values will be there.
    this table we can access. this will not be visible. but we can access. these
    type of tables are calles META DATA.

    hope you find the solution


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.