1、帶參數的存儲過程
create
or replace procedure sp_pro2 (spname varchar2, newsal number) is
begin
update
emp set sal = newsal where ename=spname;
end;
--參數varchar2不需要指定大小
exec
sp_pro2(‘smith‘,10);
或者call
1、帶參數的存儲過程
create
or replace procedure sp_pro2 (spname varchar2, newsal number) is
begin
update
emp set sal = newsal where ename=spname;
end;
--參數varchar2不需要指定大小
exec
sp_pro2(‘smith‘,10);
或者call