PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint
Cause: The mode of the specified parameter was IN OUT or OUT. Use of the NOCOPY compiler hint may speed up calls to this subprogram.
Action: Change the mode of the parameter to explicitly use the NOCOPY compiler hint. For example, if your subprogram declaration is: PROCEDURE proc(p1 IN OUT CLOB); you can change it to: PROCEDURE proc(p1 IN OUT NOCOPY clob); to get the benefit of the NOCOPY hint. For member procedures or functions in object types, you may have to explicitly declare the SELF parameter as illustrated in the following: MEMBER PROCEDURE proc(SELF IN OUT NOCOPY MY_TYPE);

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

PLW-07203：参数' string '可能受益于使用NOCOPY编译器提示,
.原因：指定参数的模式为IN OUT或OUT。使用NOCOPY编译器提示可能会加快对此子程序的调用。,
.操作：更改参数的模式以显式使用NOCOPY编译器提示。例如，如果您的子程序声明为：PROCEDURE proc（p1 IN OUT CLOB）; 您可以将其更改为：PROCEDURE proc（p1 IN OUT NOCOPY clob）; 以获得NOCOPY提示的好处。对于对象类型中的成员过程或函数，可能必须显式声明SELF参数，如下所示：MEMBER PROCEDURE proc（SELF IN OUT NOCOPY MY_TYPE）;,
.

aiaiDBA

13718043309

010-86462881

PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

1 个回答

相似问题