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-25465: variable name not specified
ORA-29364: plan directive string, string already exists
TNS-00273: Navigator: Logging is now ON
ORA-07843: sllfcl: LIB$FREE_VM failure
QSM-01111: no partition key or partition marker found in MV, string
QSM-01113: HAVING clause of mv, string, is more restrictive than query
ORA-25297: The message options only make sense for buffered messages
PCC-02425: An indicator variable is not required with this attribute
ORA-22828: input pattern or replacement parameters exceed 32K size limit
ORA-13827: null or zero length attribute specified in SQL profile collection
DRG-10751: invalid value for parameter
ORA-06314: IPA: Event set up failure