Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: triggers and functions

Re: triggers and functions

From: DStevens <dstevens_at_navidec.com>
Date: Wed, 09 Jan 2002 10:33:41 -0700
Message-ID: <a1hutj$h0f$2@newsreader.mailgate.org> 





The problem is you cannot reference the table within a trigger, that the trigger
is on.  So, within the trigger on infoglob, you can't reference infoglob.



The work-around is autonomous transactions -- there was a thread earlier this
week discussing those.



hth
Received on Wed Jan 09 2002 - 11:33:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US