我有一些用Oracle编写的程序.不幸的是我无法显示其代码.其中的某个地方是由于缺少必需的数据而选择执行崩溃的地方.看起来像这样
select value into l_value
from config
where code = upper(p_code);
execute some_package.some_procedure('CODE');
它抛出
Error report - ORA-01403: no data found ORA-06512: at "XXXXXXXXXXXXXXXXXXX",line 111 ORA-06512: at "XXXXXXXXXXXXXXXXXXX",line 111 ORA-06512: at line 1 01403. 00000 - "no data found" *Cause: No data was found from the objects. *Action: There was no data from the objects which may be due to end of fetch.
但是当我这样称呼它时
call some_package.some_procedure('CODE');
它崩溃在同一个地方(我可以从结果中建议,存储在DB中),但它没有抛出异常.
some_package.some_procedure('CODE') succeeded.
怎么了？为什么会有这样的差异？
