PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables
- 1 Answers
- 6668 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: An assignment target in the INTO list of a FETCH
statement does not match in datatype with the corresponding
column in the select list of the cursor declaration, and it
is unclear which implicit conversion is required to correct
the mismatch.
Action: Change the cursor declaration or change the datatype
of the assignment target. You might want to use datatype
conversion functions in the select list of the query
associated with the cursor.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
ORA-00290: operating system archival error occurred. See error below
ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
QSM-02010: join predicate with operator other than equals (=)
ORA-07210: slcpu: getrusage error, unable to get cpu time.
ORA-08499: Warning: picture mask options 'string' ignored by UTL_PG
ORA-00404: Convert file not found: 'string'
ORA-00220: controlfile not mounted by first instance, check alert log for more info
LCD-00217: failure while processing file parameter [string]
DRG-12206: tag string already exists in section group string
AMD-00110: parameter string of "string" not valid
QSM-02122: compatibility mode must be 8.1 or higher
PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor
Oracle Errors 
