常用的错误类型有如下几种: begin sql_statment; exception when access_into_null then <statements> when collection_is_null then <statements> when cursor_already_open then <statements> when dup_val_on_index then <statements> when invalid_cursor then <statements> when invalid_number then <statements> when login_denied then <statements> when no_data_found then <statements> when not_logged_on then <statements> when program_error then <statements> when rowtype_mismatch then <statements> when too_many_rows then <statements> when zero_divide then <statements> when value_error then <statements> when others then <statements>
END;例如:我们要写一条select语句,通常会采用如下的格式(实际的使用中很少扑捉错误3) begin select ... into .... from ....; exception when no_data_found then //1 <statements>; when too_many_rows then //2 <statements>; when rowtype_mismatch then //3 <statements> when others then //4 <SM>; end;
begin
sql_statment;
exception
when access_into_null then
<statements>
when collection_is_null then
<statements>
when cursor_already_open then
<statements>
when dup_val_on_index then
<statements>
when invalid_cursor then
<statements>
when invalid_number then
<statements>
when login_denied then
<statements>
when no_data_found then
<statements>
when not_logged_on then
<statements>
when program_error then
<statements>
when rowtype_mismatch then
<statements>
when too_many_rows then
<statements>
when zero_divide then
<statements>
when value_error then
<statements>
when others then
<statements>
END;例如:我们要写一条select语句,通常会采用如下的格式(实际的使用中很少扑捉错误3)
begin
select ... into .... from ....;
exception
when no_data_found then //1
<statements>;
when too_many_rows then //2
<statements>;
when rowtype_mismatch then //3
<statements>
when others then //4
<SM>;
end;