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

Home -> Community -> Usenet -> c.d.o.server -> Re: OLD NEW value in trigger ?

Re: OLD NEW value in trigger ?

From: eugene kim <eugene1977_at_hotmail.com>
Date: Tue, 17 Sep 2002 23:45:22 +0000
Message-ID: <am7leh$hei$1@newsreader.mailgate.org>


thx that cleared out a lot..

yeah i didn't notice that i used after statement level trigger instead of row level..

in statement trigger, NEW & OLD are not accessible, so only way to access data in the table(inside statement trigger) is to use some sort of temporary structure(table, package) as i would do to solve the 'mutating error'..?

thanks Received on Tue Sep 17 2002 - 18:45:22 CDT

Original text of this message

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