PL/SQL 异常处理

来源：互联网发布：江苏软件考试网编辑：程序博客网时间：2024/04/26 19:56

SQL> set serveroutput on
SQL> declare
name varchar2(10);
begin
select ename into name from emp where empno = &no;
dbms_output.put_line(name);
EXCEPTION
when NO_DATA_FOUND THEN
    dbms_output.put_line('该雇员不存在');
end; 2    3    4    5    6    7    8    9
10 /
Enter value for no: 7369
old   4:   select ename into name from emp where empno = &no;
new   4:   select ename into name from emp where empno = 7369;
SMITH

PL/SQL procedure successfully completed.

---------------------------------------------------------------------
create or replace procedure test_proc2(no number) IS
name varchar2(10);
begin
select ename into name from emp where empno = no;
dbms_output.put_line(name);
EXCEPTION
when NO_DATA_FOUND THEN
dbms_output.put_line('this employees is not exits');
end;

SQL> exec test_proc2(7369);
SMITH

PL/SQL procedure successfully completed.

SQL> exec test_proc2(10000);
this employees is not exits

PL/SQL procedure successfully completed.

0 0