Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: OLD NEW value in trigger ?
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
![]() |
![]() |