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-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.

1 Answers  


ORA-16556: Error message is in XML already.

1 Answers  


ORA-24295: max key length (string) for sorted hash cluster exceeded

1 Answers  


ORA-14450: attempt to access a transactional temp table already in use

1 Answers  


TNS-12582: TNS:invalid operation

1 Answers  


PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  


ORA-01291: missing logfile

1 Answers  


ORA-03204: the segment type specification should indicate partitioning

1 Answers  


NNL-00549: Displays stream usage statistics

1 Answers  


ORA-01078: failure in processing system parameters

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


Categories