> I can't give you an exact version but it is somewhere in the 7.0 > releases. I've been doing an UPDATE ... WHERE CURRENT OF SYS_NEW for some > time.
Cool. And I thought I read all of the update memos! A few questions: Is this only in AFTERs, or does it work in BEFOREs also? Are you guaranteed not to invoke a call to the trigger you're UPDATEing from? Do you have to worry about cross-trigger calls? That is, if you UPDATE in the AFTER INSERT trigger, do the BEFORE and AFTER UPDATE triggers get called? -- Larry
