Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: Tracking in Oracle

    Hi

    I need to follow a pocedure in an oracle database.
    Does anyone know of an (simple) application that I can use for this.
    I need to create an Invoice and then find out what fields are updated and
    if thoose fields triggers other fields to be updated.

  2. #2
    Join Date
    Sep 2002
    Location
    Austria
    Posts
    37

    Re: Tracking in Oracle

    Originally posted by Chrille
    Hi

    I need to follow a pocedure in an oracle database.
    Does anyone know of an (simple) application that I can use for this.
    I need to create an Invoice and then find out what fields are updated and
    if thoose fields triggers other fields to be updated.
    not really sure what you want to do, but:
    define triggers on all those tables you want to watch.
    you can restrict the trigger to fire only when certain columns are updated ...

    like :

    CREATE TRIGGER hr.salary_check
    BEFORE INSERT OR UPDATE OF salary, job_id ON hr.employees
    FOR EACH ROW
    WHEN (new.job_id <> 'AD_VP')
    CALL check_sal(:new.job_id, :new.salary, :new.last_name);

    source: http://download-uk.oracle.com/docs/c...6a.htm#2064378

    hope it helped a bit

  3. #3
    Join Date
    Aug 2003
    Posts
    2
    I'm not not sure myself..... but I need to know exactly what tables are updated in oracle if I enter information into certain fields in an application. I know I can extract an sql query to get information about the db fields but when it comes to the Invoice bit it seems like one fields updates another and I need to know exactly what fields.

  4. #4
    Join Date
    Sep 2002
    Location
    Austria
    Posts
    37

    trigger on any table (on any field) ??

    Originally posted by Chrille
    I'm not not sure myself..... but I need to know exactly what tables are updated in oracle if I enter information into certain fields in an application. I know I can extract an sql query to get information about the db fields but when it comes to the Invoice bit it seems like one fields updates another and I need to know exactly what fields.
    still somewhat confused by the "invoice-statement", but anyhow.

    I assume now: the invoice you want to create is something like "an update per table costs n dollars each, an update per column costs m dollars ..."
    If you cannot restrict the update to certain tables and/or columns, then you would have to create a trigger on ANY table, maybe even on ANY Column. thats not really complicated (you can always use the same pattern or template), it's only a bit strange and might have some performance implications, depending on what the trigger should actually do.
    hope i did understand you a bit more, now

  5. #5
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Tracking in Oracle

    Originally posted by Chrille
    Hi

    I need to follow a pocedure in an oracle database.
    Does anyone know of an (simple) application that I can use for this.
    I need to create an Invoice and then find out what fields are updated and
    if thoose fields triggers other fields to be updated.
    I think you are essentially asking - "How do I preform a trace from my client/program to the database?"

    Then after the trace completes, you'll have to look at the triggers/constraints on the table(s) and column(s) to figure out what else is going on.

    I don't know the steps, but I'm sure someone will be able to help you once the phrasing is put properly.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  6. #6
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Re: Tracking in Oracle

    I see you use both forum too.

    Hey Gang,
    I need to track the User and table activity. My goal is to find out what tables are static and which are not. Which user classes should be changed and how access should be assigned. This will also allow me to tune the database accordingly.

    Originally posted by Chrille
    Hi

    I need to follow a pocedure in an oracle database.
    Does anyone know of an (simple) application that I can use for this.
    I need to create an Invoice and then find out what fields are updated and
    if thoose fields triggers other fields to be updated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •