PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables



PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations

1 Answers  


ORA-02425: create table failed

1 Answers  


SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

1 Answers  


NNL-00513: Shows or sets the server's auto-refresh failure retry interval

1 Answers  


DRG-52200: invalid state during export

1 Answers  






ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 Answers  


ORA-07226: rtneco: unable to get terminal mode.

1 Answers  


ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified

1 Answers  


NNL-00559: Shows, sets, or cancels the time for the next cache dump to the trace file

1 Answers  


ORA-26101: tablespace # in file header is string rather than string for file string

1 Answers  


ORA-16079: standby archival not enabled

1 Answers  


ORA-02774: Invalid request list latch time out value

1 Answers  


Categories