mutation problem in triggers

From: <smrfld42_at_ix.netcom.com>
Date: 1998/03/05
Message-ID: <6dnld9$7br$1@nnrp1.dejanews.com>#1/1

I was wondering if anyone could tell me why these two triggers are conflicting. I get the following error:

ERROR at line 1:
ORA-04091: table CONTACT.PERSONAL_INFO is mutating, trigger/function may not see
 it
ORA-06512: at "CONTACT.PERSONAL_POSTINSERT", line 4 ORA-04088: error during execution of trigger 'CONTACT.PERSONAL_POSTINSERT'

CREATE OR REPLACE TRIGGER personal_preinsert BEFORE INSERT ON personal_info
FOR EACH ROW
BEGIN
/*Set the value of the key for the parent table*/

	SELECT contact_personal_seq.nextVal INTO :new.personal_key
		FROM dual;

END; CREATE OR REPLACE TRIGGER personal_postinsert AFTER INSERT ON personal_info
FOR EACH ROW
BEGIN
/*Create records in child tables with NULL Values*/
/*Contact Table*/

        INSERT INTO contact_info VALUES
(contact_contact_seq.NEXTVAL ,NULL,NULL,NULL, NULL,NULL, NULL,NULL,NULL,NULL, NULL, NULL,contact_personal_seq.currval);

/*Additional Table*/

        INSERT INTO additional_info VALUES
(contact_additional_seq.NEXTVAL,NULL, contact_personal_seq.CURRVAL); END; -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 05 1998 - 00:00:00 CST