Re: Mutating triggers

Yes, there is a trick. It's really complicated, though, and involves three triggers (Before statement/stmt level, after statement/row level, after statement/statement level), one procedure, one function, and one package.

Let me know if you're still interested and I'll email you the code (really humongous, though).

Christina Schriver
Sr. Principal Analyst
Metters Industries, Inc.

Chris Halioris wrote:
>
> Therefore I created a database trigger to check if parm_code = 'A' then
> see if there are any other records with parm_code = 'A' and code_value =
> :new.code_value (and if there is I raise_application_error). The trigger
> works fine for an insert but mutates on an update. Is there a trick to
> doing something like this, or a better way?
>
> Chris Halioris
Received on Thu Jan 23 1997 - 00:00:00 CET