مساعدة في الخطا التالي Pls-00103

CREATE OR REPLACE TRIGGER update_date_pill

AFTER INSERT OR UPDATE

ON NEW_PAID_PILL_BUILDING

REFERENCING NEW AS New OLD AS Old

FOR EACH ROW



DECLARE

  tmpVar NUMBER;

   



BEGIN 

       :old.PAID_FROM_G_DATE:=h2g(:new.PAID_FROM_h_DATE);

       :old.PAID_TO_G_DATE:=h2g(:new.PAID_TO_h_DATE);     

       :old.PILL_FROM_G_DATE:=h2g(:new.PILL_FROM_h_DATE);

       :old.PILL_TO_G_DATE:=h2g(:new.PILL_TO_h_DATE);

END;