begin
select col1 into values from table_name; --insert, update
exception
when others then
.......
end;
select col1 into values from table_name; --insert, update
exception
when others then
.......
end;
调试欢乐多
select c_xianlu from T_cheliang where c_cardno=CardNo; begin
exception when no_data_found then
BusLine:='0';
end;
如果不加exception的话就出错了,但加了之后虽然不出错但也没有运行BusLine:='0';这一句了.
http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=103401