Oracle Error Message
PLS-00438: value in LIMIT clause: ‘string’ use is invalid
Reason for the Error
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
Solution
Change the expression of the LIMIT clause so that the evaluation result is compatible to a numeric value.