Oracle Error PLS-00438: value in LIMIT clause: ‘string’ use is invalid

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.