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.

No comments:

Post a Comment