PL/SQL 异常处理

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.