Submitted Questions

  • What is a mutating trigger error? How can we resolve it?I need this reply asap. Thanks

    Ashish

    • Mar 24th, 2012

    See, in oracle to maintain read consistency oracle keeps a copy in undo section of database for the data which is under modification by some transaction. And so readers do not wait for writers and ca...

    Kranthi

    • Jul 13th, 2011

    In before update/delete trigger if we use select statement for fetching the records.in this scenario will wet mutating trigger error.using row level trigger we can avoid instead of statement level trigger. we can accurate results.