PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables
- 1 Answers
- 6664 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-39709: incomplete component downgrade; string downgrade aborted
ORA-27193: sbtinfo2 did not return volume label
ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.
NNC-00431: NS address does not match any of the current addresses
ORA-29290: invalid offset specified for seek
ORA-16703: cannot set the property while the database is enabled
ORA-22814: attribute or element value is larger than specified in type
ORA-02254: DEFAULT <expression> not allowed here
DRG-12011: Authentication failed - retry?
ORA-31490: could not attach to LogMiner session
NNL-00509: set|show cache_checkpoint_interval [<seconds>] [<server_list>] : set|show the server's cache checkpoint interval
NNO-00056: warning: domain minimum TTL must be between number and number, set to number seconds
Oracle Errors 
