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;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)