Mutating

From: Business Information Services <email_at_bisinfo.com.au>
Date: 1997/06/10
Message-ID: <MPG.e07759eaa6e0a29989696@nsw-newshost.tpgi.com.au>#1/1

Greeting all!

We have a before insert and update trigger set up on a table called "FILLER_RUN" with the following code.

DECLARE
    MAX_DATE date;
BEGIN     SELECT MAX(EFFECTIVE_FROM)
    INTO MAX_DATE
    FROM FILLER_RUN
    WHERE RUN_FK = :NEW.RUN_FK;     ... if .. then etc.
END; A "run" can have many "effective from" dates. The purpose of this query is to find the current maximum effective date for a run which we then compare with the date the user is trying to enter. If it is less than or equal to the max date for that run then we raise an exception.

We are getting a mutating table error but we thought that this only occured when you tried to change something in the trigger. All we are doing is reading from the database.

Can anyone help out?

Regards,
Peter.

-- 
Business Information Services
(For more information call Brad Deveson)

Tel: (02) 9387-2509 (Australia)
Fax: (02) 9369-3840 (Australia)
mailto:email_at_bisinfo.com.au
http://www.bisinfo.com.au

Received on Tue Jun 10 1997 - 00:00:00 CDT