> You have to be careful about using triggers to alter the table on which the > trigger is based. We do this, but only to update the row that triggered > the action in the first place by using "where current of ..." This will > not cause the trigger to fire again.
I recall trying something like this some time ago and finding that the SYS_NEW and SYS_OLD cursors did _not_ allow updating. Am I mistaken, or is this something that changed in an in-line release of the product? -- Larry
