create or replace usp_saveinfo_student(v_code varchar2,v_name varchar2,v_age number,v_grade varchar2,v_messcode number,v_messtext varchar2)
is
begin
if v_age<7 and v_grade=1 then
v_messcode:=101;
v_messtext:='一年级不可以小于7周岁';
return;
end if;
if v_age>15 and v_grade=5 then
v_messcode:=101;
v_messtext:='五年纪不可以大于15周岁';
return;
end if;
insert into t_student(code,name,age,grade) values(v_code,v_name,v_age,v_grade);
commit;
v_messcode:=0;
v_messtext:='学生信息保存成功!';
end;
温馨提示:答案为网友推荐,仅供参考