What's wrong with this trigger?

I could create this trigger, but it didn't do what I wanted. Thanks for your input.

CREATE OR REPLACE TRIGGER pic_trg_aiur BEFORE INSERT OR UPDATE   OF status_yn ON picture
  FOR EACH ROW BEGIN
  IF :new.status_yn = 'Y' THEN
    UPDATE picture

       SET pic_ob = empty_blob()
    WHERE pic_id = :new.pic_id;
  END IF;
EXCEPTION
  ..
END;
/

H Received on Tue Aug 15 2000 - 19:37:08 CDT