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 |
ORA-38705: Expected block size string does not match string in log header.
ORA-19852: error creating services for auxiliary instance string (error string)
ORA-00104: deadlock detected; all public servers blocked waiting for resources
ORA-02772: Invalid maximum server idle time
AMD-00106: parent string "string" must be removed before child string "string" can be removed
DRG-11602: URL store: access to string requires authentication
ORA-02289: sequence does not exist
PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements
ORA-07425: sdpri: error string in translating dump file location.
ORA-14082: new partition name must differ from that of any other partition of the object
SQL*Loader-00941: Error during describe of table string
ORA-19687: SPFILE not found in backup set