ORACLE存储过程警惕(删除记录)

错误

create or replace procedure del_team
(
  userid in t_user.id%type,
  teamid out t_user.teamid%type

)
as
begin
  select t.teamid into teamid from t_user t where t.id=userid;
  delete from t_user t where t.id=userid;
  delete from t_gps t where t.userid=userid;
commit;
end;

删除某条记录，会删除表的全部数据。

问题是变量命名问题，如下解决(切记变量命名，不与系统字段或是变量以及其他关键字冲突)：

-------------------------------------------------------------------------------------------------------

正确

create or replace procedure del_team
(
  v_userid in t_user.id%type,
  v_teamid out t_user.teamid%type

)
as
begin
  select t.teamid into v_teamid from t_user t where t.id=v_userid;
  delete from t_user t where t.id=v_userid;
  delete from t_gps t where t.userid=v_userid;
commit;
end;