NO_DATA_FOUND.Exception 如何触发?有点不明白了,
我写了个最简单的SQL ,为什么不能触发?
....
SELECT count(*) INTO v_NUM FROM dual where 1=2;
EXCEPTION
WHEN NO_DATA_FOUND THEN
po_error_info := to_char(v_NUM) ;
WHEN OTHERS THEN
po_error_info :='Proc : ' + SUBSTR(SQLERRM, 1, 100);
END Proc;
我写了个最简单的SQL ,为什么不能触发?
....
SELECT count(*) INTO v_NUM FROM dual where 1=2;
EXCEPTION
WHEN NO_DATA_FOUND THEN
po_error_info := to_char(v_NUM) ;
WHEN OTHERS THEN
po_error_info :='Proc : ' + SUBSTR(SQLERRM, 1, 100);
END Proc;
no_data_found 、 sql%notfound ,前面二种我明白了,
sql%rowcount没用过,什么时候触发?
sql%notfound be springed by ‘update ...’or ‘delete...’;