create or replace procedure sp_insert_dept( p_deptno in number, 
                                            p_dname in varchar2, 
                                            p_loc in varchar2 )
is
begin
  insert into dept
  values(p_deptno,p_dname,p_loc);
  commit;
end sp_insert_dept;

-- 调用
begin
    sp_insert_dept(80,'BI开发部','广州');
end;