sql - INSERT trigger which with the INSERT statements within -

in cases when record inserted table, should split few records, inserted instead.

the logic written inside insert trigger, fires before insert operation. inside of trigger trying execute insert statement, subsequently causes recursive call of trigger. not want happen. tried disable trigger body using smth

execute immediate 'alter trigger sale_trigger disable';

but, commit operation , doesnt work inside of trigger.

how can around recursive call of trigger?

edit declared trigger declare pragma autonomous_transaction; , can run alter statement. when disable trigger same trigger - plsql developer stops working. do? :)

instead of loading first insert directly target table, insert records staging table. trigger troublesome logic should on staging table. if logic not apply, trigger inserts row target table. if logic applies, trigger inserts row (if necessary?) , fires off whatever additional inserts target table required. truncate staging table on regular intervals keep small , efficient (but not after each trigger operation since less efficient).

in other words: decouple trigger table inserting into.