Forum Stats

  • 3,853,599 Users
  • 2,264,243 Discussions
  • 7,905,405 Comments

Discussions

Oracle PLSQL Trigger Question

790605
790605 Member Posts: 9
edited Oct 21, 2010 9:09PM in SQL & PL/SQL
Hi Everybody,

I am facing an issue in trigger.

Basically my requirement is that i have a front end java application which do batch update(modify) from the front end screen on a table 'A' on a single column.

Is it possible to make the trigger fire only once after all the batch updates rather than multiple times.

Your help is really appreciated.

-Manohar
Tagged:

Answers

  • Hoek
    Hoek Member Posts: 16,087 Gold Crown
    edited Oct 21, 2010 9:09PM
    Assuming that trigger is on table A: What does your trigger do?
    And what issue are you facing exactly?
    Are you getting an error?
    Please provide the relevant details, including your database version.
    Is it possible to make the trigger fire only once after all the batch updates rather than multiple times.
    That depends on
    - Is your batch updating multiple rows at once or doing row-by-row updates?
    - Is your trigger defined at row level (for each row) or at statement level?
    Perhaps you're even better off without the trigger...

    Just in case you're hitting the famous mutating table error, see:
    http://www.oracle-base.com/articles/9i/MutatingTableExceptions.php
    http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551198119097816936
This discussion has been closed.