-- Listing 7-20. PL/SQL Code to Insert a New Employee Record
begin
    insert into EMP(EName, Job, Mgr, Sal, DeptNo, HireDate, Comm, Offsite)
    values (:P20_INSERT_ENAME, 
            :P20_INSERT_JOB, 
            :P20_INSERT_MANAGER,
            :P20_INSERT_SALARY,
            :P20_INSERT_DEPTNO,
            current_date,  0,  'N');

    -- Clear the region's visible items.
    :P20_INSERT_ENAME   := null;
    :P20_INSERT_JOB     := null;
    :P20_INSERT_MANAGER := null;
    :P20_INSERT_SALARY  := null;
    :P20_INSERT_DEPTNO  := null;

    -- But do not change the mode.
end;

