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

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

Question Posted / guest

1 Answers
7004 Views
I also Faced
E-Mail Answers

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