create  procedure update_sal(name1 varchar2(20),newsal number)
is
begin
 update emp set sal=newsal
 where lower(ename)=lower('name1');
end;

exec update_sal('king',3000);

ORA-06550: 第 2 行, 第 7 列: 
PLS-00905: 对象 SCOTT.UPDATE_SAL 无效
ORA-06550: 第 2 行, 第 7 列: 
PL/SQL: Statement ignored

create OR REPLACE procedure update_sal(name1 IN varchar2,newsal IN NUMBER)
is
begin
 update emp set sal=newsal
 where lower(ename)=lower(name1);
end;