请问简单的存储过程内层查询内层捕捉的方法?
czb 2004-12-16 09:49:05 create or replace procedure TestProc(p_id varchar2)as
l_name test.name%type;
begin
.....
select name into l_name from test where id=p_id; ---这上下行该如何加上异常捕捉?
.....
if l_name is null then
dbms_out.putline(...);
else
dbms_out.putline(...);
end if;
end TestProc;