PLW-07206: analysis suggests that the assignment to 'string' may be unnecessary

PLW-07206: analysis suggests that the assignment to 'string' may be unnecessary
Cause: This assignment may be unnecessary; the PL/SQL optimizer could not find any further use of the variable which was being set. If the assignment was being done for some side-effect such as raising a specific exception, the compiler may not have been able to understand the side-effect and this warning may be inappropriate.
Action: If the assignment sets a variable whose value will not be used again and there are no side-effects (exceptions or calls) to consider, remove the assignment for better performance. If the assignment was in place to raise a specific known exception, replace the assignment with a RAISE statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

PLW-07206：分析表明，对' string ' 的赋值可能是不必要的,
.原因：此作业可能不必要; PL / SQL优化器找不到正在设置的变量的进一步使用。如果对某些副作用进行任务，例如提出特定异常，编译器可能无法理解副作用，并且此警告可能不合适。,
.操作：如果赋值设置一个变量，其值将不再被使用，并且没有副作用（异常或调用）要考虑，则删除该赋值以获得更好的性能。如果赋值是为了引发特定的已知异常，请使用RAISE语句替换该赋值。,
.,
.,
.

aiaiDBA

13718043309

010-86462881

PLW-07206: analysis suggests that the assignment to 'string' may be unnecessary

1 个回答

相似问题