Oracle概念:异常和游标

核心提示： when l_exc then…end;/PRAGMA EXCEPTION_INITDeclareL_update_text varchar2(100):=‘update &table_name set &updated_column_name= ‘&

when l_exc then

…

end;

/

PRAGMA EXCEPTION_INIT

Declare

L_update_text varchar2(100):=

‘update &table_name set &updated_column_name= ‘’:a’’

where &key_column_name=:a’;

begin

execute immediate L_update_text using ‘&updated_column_value’, &key_column_value;

end;

/

Declare

Invalid_column_name exception;

Pragma exception_init(Invalid_column_name,-904);

L_update_text varchar2(100):=

‘update &table_name set &updated_column_name= ‘’:a’’

where &key_column_name=:a’;

begin

execute immediate L_update_text using ‘&updated_column_value’, &key_column_value;

exception

when Invalid_column_name then

dbms_output.put_line(‘hehe’);

end;

/

异常传播：

begin

begin

begin

begin

begin

declare

fname employees.first_name%type;

begin

select first_name into fname from employees where 1=2;

--exception

--when NO_DATA_FOUND then

-- dbms_output.put_line(‘block 6’);

end;

exception

when NO_DATA_FOUND then

dbms_output.put_line(‘block 5’);

end;

exception

when NO_DATA_FOUND then