PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables
- 1 Answers
- 6812 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-01503: CREATE CONTROLFILE failed
ORA-03002: operator not implemented
ORA-30934: 'string' (string node) cannot be inserted in parent 'string' (string node)
ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types
ORA-26000: partition load specified but table string is not partitioned
ORA-14263: new subpartition name must differ from that of any other subpartition of the object
ORA-22283: filename contains characters that refer to parent directory
RMAN-06075: datafile string does not belong to this database
ORA-01286: start interval required
ORA-23601: PROPAGATION_NAME string does not exist
ORA-24395: cannot reinitialize non-existent pool
Oracle Errors 
