我們通常在SQL> Prompt(提示符)下編寫一個procedure做測試或調試時會用到dbms_output來輸出一些提示信息。我們可以通過這些信息來了解咝袪顩r。可是我們咝泻笤谄聊簧陷敳怀鰞热荨_@是為什么呢。呵呵,在SQL> 提示符下要讓serveroutput 這個開關打開才可以(
SQL> set serveroutput on ).
SQL> declare
2 v_ename emp%rowtype;
3 begin
4 select * into v_ename from emp where empno=-1;
5 if sql%notfound then
6 dbms_output.put_line('sql%notfound is true!');
7 end if;
8 exception
9 when no_data_found then
10 dbms_output.put_line('NO_DATA_Found is true!');
11 end;
12 /
PL/SQL procedure successfully completed.
SQL> /
PL/SQL procedure successfully completed.
SQL> set serveroutput on
SQL> /
NO_DATA_Found is true!
PL/SQL procedure successfully completed.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51740/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29987/viewspace-51740/