我有一些用Oracle编写的过程。不幸的是,我无法显示其代码。它内部的某个地方是选择由于缺少所需数据而执行崩溃的位置。看起来像这样
select value into l_value
from config
where code = upper(p_code);
因此,当我像这样调用此过程时(在 SqlDeveloper 中(
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');
它在同一个地方崩溃(正如我可以从结果中建议的那样,存储在数据库中(,但它不会引发异常。
some_package.some_procedure('CODE') succeeded.
会发生什么?为什么会有这样的差异?
NO_DATA_FOUND
异常行为是特殊的。默认情况下,它在SQL上下文中处理,但不在PL/SQL中处理。在SQL中,找不到任何数据不被视为错误,它总是发生没有满足特定条件的数据。
CALL
是SQL命令,而EXEC
是PL/SQL BEGIN <code> END;
的快捷方式。