declare
e_name varchar2(20);
begin
select ename into e_name from emp
where empno = '0000';
exception
when others then
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
end;
/
100
ORA-01403: 未找到数据
declare
e_name varchar2(20);
begin
select ename into e_name from emp
where empno = '0000';
exception
when others then
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
end;
/
100
ORA-01403: 未找到数据