PLS-00438: value in LIMIT clause: 'string' use is invalid
- 1 Answers
- 3143 Views
- I also Faced
- E-Mail Answers
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 |
PCC-00073: Cursor is declared but never OPENed at line number in file string.
ORA-12222: TNS:no support is available for the protocol indicated
ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string
DRG-11504: invalid longsize parameter of string specified
ORA-12205: TNS:could not get failed addresses
ORA-00305: log string of thread string inconsistent; belongs to another database
DRG-11700: thesaurus string already exists
ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set
ORA-00303: cannot process Parallel Redo
DRG-11524: primary key value is missing
ORA-06041: NETDNT: disconnect failed
PCB-00223: Undeclared variable "string"
Oracle Errors 
