Re: NEWBIE: ORA 4091-TRIGGER CANNOT SEE TABLE

From: Jan Rosinowski <rosinowski_at_gmx.de>
Date: Wed, 03 Mar 1999 07:58:27 GMT
Message-ID: <36dcde2b.661182289@bigXb>

>But what if B was to be updated first? Get the picture? Results would be
>unpredictable.

no, as the version in fact is a date. anyway, that would be a design problem but not something oracle should take care of just in case i had a blonde moment :-)

is that simply a harassment or are there real technical problems involved?

looks somewhat similar to the restrictions for stored functions where one has to use these "everything will be ok"-pragmas.. if one returns results thru out-params of a stored procedure one can wipe the whole db in the meantime. queer logic

ciao, jan Received on Wed Mar 03 1999 - 01:58:27 CST