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;