PLS-00438: value in LIMIT clause: 'string' use is invalid

PLS-00438: value in LIMIT clause: 'string' use is invalid
Cause: The evaluation value in the LIMIT clause of a bulk fetch was found in an inappropriate context. For example, the following statement is illegal because the LIMIT clause in a bulk fetch expects a numeric value. FETCH c1 BULK COLLECT INTO var_tab LIMIT '22333'; -- illegal
Action: Change the expression of the LIMIT clause so that the evaluation result is compatible to a numeric value.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00438：LIMIT子句中的值：' string '用法无效,
.原因：批量提取的LIMIT子句中的评估值在不适当的上下文中找到。例如，以下语句是非法的，因为批量提取中的LIMIT子句需要一个数字值。FETCH c1 BULK COLLECT INTO var_tab LIMIT'22333'; - 非法,
.操作：更改LIMIT子句的表达式，以使评估结果与数值相兼容。,
.

aiaiDBA

13718043309

010-86462881

PLS-00438: value in LIMIT clause: 'string' use is invalid

1 个回答

相似问题