Inserting values via Oracle form in Oracle database

See more:

Oracle

I'm facing a problem in inserting values in ndatabase using oracle form.

I placed a trigger When-Button-Pressed against save button in the form but I don't know what is actualy going wrong.

The code in the trigger is as:

DECLARE
  --declarations;
  fn varchar2(400);
  fa varchar2(40);
BEGIN
 -- INSERT_RECORD;
 fn:= :BLK_IIU_FACULTY.Fac_Name;
 MESSAGE ('faculty name '||fn);
 fa:= :BLK_IIU_FACULTY.Fac_Abbrv;
 insert into IIU_Faculty Values(FacultySeq.nextval,fn,fa);
COMMIT_FORM; --COMMIT;
 select FAC_NAME into fn from IIU_FACULTY where FAC_ID=3;
 MESSAGE(fn);
END;