trigger « Oracle « JPA Q&A

  1. JPA Q&A
  2. Oracle
  3. trigger




1. ORA-04091: table [blah] is mutating, trigger/function may not see it    stackoverflow.com

I recently started working on a large complex application, and I've just been assigned a bug due to this error: 

ORA-04091: table SCMA.TBL1 is mutating, trigger/function may not see it
ORA-06512: at "SCMA.TRG_T1_TBL1_COL1", ...

2. moving logic from pl/sql trigger to java    forum.hibernate.org

Hello I have to move some part of logic placed in ORACLE triggers to java and involve hibernate as much as possible. Triggers store logic such as - validating data, using :old and :new variables (%rowtype of according table), often performing selects of current or other tables. - updating some fields of :new - updating or inserting records of other tables. ...