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

DRG-12515: cannot specify language for stopwords in a BASIC_STOPLIST

1 Answers  


PLS-01468: The first argument of the like-predicate must be a column of type character string

1 Answers  


PROC-00010: Cannot delete the cluster registry key as subkeys exist.

1 Answers  


TNS-01058: Arguments : string

1 Answers  


ORA-28592: agent control utility: agent SID not set

1 Answers  


ORA-32332: cannot refresh materialized view "string"."string" as type evolution has occured

1 Answers  


ORA-22612: TDS does not describe a collection TDS

1 Answers  


ORA-14451: unsupported feature with temporary table

1 Answers  


ORA-31080: type not specified for attribute or element "string"

1 Answers  


TNS-12540: TNS:internal limit restriction exceeded

1 Answers  


DRG-11709: too many terms in thesaurus

1 Answers  


LCD-00203: missing keyword [string]

1 Answers  


Categories