create or replace procedure Test_Dept(param1 in NUMBER,param2 in VARCHAR2,param3 in VARCHAR2) as
begin
insert into DEPT(DEPTNO,DNAME,LOC)values(param1,param2,param3);
end Test_Dept
------解决方案--------------------

------解决方案--------------------
直接在命令窗口 call Test_Dept(1,2,3)
或者在pl/sql中
declare
begin
Test_Dept(1,2,3);
end;