Quick Student Question

[FlyinFungi]

Hi, I have a very easy student question. (Hope its easy!)

I am trying to do the following...
Before you update the PART table each row in that table with a warehouse equal to one set the price of that part to $100

CREATE OR REPLACE TRIGGER TRG_PART_UPDATE
BEFORE UPDATE ON PART
BEGIN
UPDATE PART
SET PRICE =100
WHERE WAREHOUSE=1;
END;

But if I make any sort of update such as.

UPDATE PART
SET PART_NUM ='AT99'
WHERE PART_NUM ='AT91';

I get the following error...

ORA-06512: at "SYSTEM.TRG_PART_UPDATE", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TRG_PART_UPDATE'
ORA-06512: at "SYSTEM.TRG_PART_UPDATE", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TRG_PART_UPDATE'
ORA-06512: at "SYSTEM.TRG_PART_UPDATE", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TRG_PART_UPDATE'
ORA-06512: at "SYSTEM.TRG_PART_UPDATE", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TRG_PART_UPDATE'
ORA-06512: at "SYSTEM.TRG_PART_UPDATE", li1. UPDATE PART
2. SET PART_NUM ='AT99'
3. WHERE PART_NUM ='AT91';

Is this because I am creating a recursive statement and it continually updates itself? I looked up the error message via google but it provides no help.

Thanks for any help!