Post reply

Stored procedure into a Trigger ???

  • September 8, 2005 at 7:17 pm

    #110765

    Hi there!

    Just a question, is it possible to call a STORED PROCEDURE from a TRIGGER?

    I ask this because I have a table, it has personal data, you know, name, address, phone, etcetera, I have to create a table that works as a LOG, where I'm going to keep records of who, when and what updatings are made to the data, name for example, and I have an UPDATE TRIGGER already for other things, so I think that I have to include into this trigger the new statements for this LOG, but the statements are too much, so I want to know if it's possible to make a call to a stored procedure, sending parameters.

    I know that I can have more triggers, but I had already an experience with triggers, and at least in my case I work better with stored procedures, so I don't want to have too many triggers, how many could be recommended in this case?, my database has many accesses in the day, so I dont want to decrease performance.

    What could you recommend me?

    Thanks a lot, regards everybody,


    L.I. Amaury C.R.

  • September 8, 2005 at 9:25 pm

    #588609

    Auditing is exactly why the triggers were created. The task should all be done there. Just add the required insert statement inside the current triggers and you'll be fine (depending on what you need to audit).

  • September 9, 2005 at 9:46 am

    #588764

    THANKS A LOT!


    L.I. Amaury C.R.

  • September 9, 2005 at 9:48 am

    #588765

    HTH.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply