Re: NEWBIE: ORA 4091-TRIGGER CANNOT SEE TABLE

Jan Rosinowski schrieb:
>
> for performance reasons i want to mark the "last" version of a tupel
> using a trigger (item,version,isnewest, primary key(item,version)).
>
> this implies that i have to reset the isnewest field for an older
> version.
>
> ...ora 4091... table is mutation, trigger may not see it...
>
> what am i doing wrong or how can i circumvent this? no recursion can
> happen and cascading triggers shouldn't be too difficult to implement
> for oracle?!
>
> ora 7.3.4
>
> ciao, jan

send example there might be a way.

Matthias
--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Wed Mar 03 1999 - 02:23:13 CST