关于oracle中return的问题create or replace procedure p_test(p_id in number(10),p_name in number)isbe
关于oracle中return的问题
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是直接返回出过程,还是其他的?希望各位讲详细些...
[解决办法]
