Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-15022: parameter length 'string' is longer than string

1 Answers  


ORA-36669: (XSDPART07) string is not a legal LIST partition.

1 Answers  


ORA-27001: unsupported device type

1 Answers  


ORA-01201: file string header failed to write correctly

1 Answers  


DRG-13001: sub lexer and multi lexer must have the same owner

1 Answers  


RMAN-08001: restore not complete

1 Answers  


NNL-00830: Delete requests received: number

1 Answers  


ORA-38767: flashback retention target parameter mismatch

1 Answers  


PLS-00249: Invalid WITH CONTEXT Syntax

1 Answers  


ORA-07216: slghst: gethostname error, unable to get name of current host.

1 Answers  


NCR-03010: NCRO: Transfer callback error

1 Answers  


RMAN-06608: RMAN configuration has no stored or default parameters

1 Answers  


Categories