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

PCC-00073: Cursor is declared but never OPENed at line number in file string.

1 Answers  


ORA-12222: TNS:no support is available for the protocol indicated

1 Answers  


ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string

1 Answers  


DRG-11504: invalid longsize parameter of string specified

1 Answers  


ORA-12205: TNS:could not get failed addresses

1 Answers  


ORA-00305: log string of thread string inconsistent; belongs to another database

1 Answers  


DRG-11700: thesaurus string already exists

1 Answers  


ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

1 Answers  


ORA-00303: cannot process Parallel Redo

1 Answers  


DRG-11524: primary key value is missing

1 Answers  


ORA-06041: NETDNT: disconnect failed

1 Answers  


PCB-00223: Undeclared variable "string"

1 Answers  


Categories