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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00103: document structure does not match DTD

1 Answers  


TNS-00203: Unable to start tracing in intlsnr

1 Answers  


ORA-09363: Windows 3.1 Two-Task driver invalid context area

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values

1 Answers  






ORA-12800: system appears too busy for parallel query execution

1 Answers  


LPX-00246: missing system ID after public ID

1 Answers  


ORA-24132: table name string is too long

2 Answers  


ORA-00378: buffer pools cannot be created as specified

1 Answers  


ORA-03243: destination dba overlaps with existing control information

1 Answers  


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

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


Categories