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;