create or replace procedure p_test
(
p_id in number(10),
p_name in number
)is
begin
begin
select id from test where id=p_id;
exception
when no_data_found then
return;
end;
begin
select id from test where id=p_id and name=p_name;
exception
when no_data_found then
return;
end;
begin
update test set name=:p_name where id=p_id;
exception
when others then
rollback;
return;
end;
end;
小弟想问一下，就是我这里的三个return是直接返回出过程，还是其他的？希望各位讲详细些...
------解决方案--------------------