Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-29308: view TS_PITR_CHECK failure

1 Answers  


ORA-06007: NETASY: bad dialogue format

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  


ORA-02233: invalid CLOSE mode

1 Answers  


ORA-06773: TLI Driver: error reading command

1 Answers  






LSX-00146: element or attribute is improperly defined

1 Answers  


ORA-15127: ASM file name 'string' cannot use templates

1 Answers  


IMG-00582: output format does not support the specified interleave

1 Answers  


ORA-12488: maximum label does not dominate minimum label

1 Answers  


TNS-12569: TNS:packet checksum failure

1 Answers  


PCC-02321: only subtraction between two pointers is permitted

2 Answers  


NZE-28759: failure to open file

1 Answers  






Categories