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

RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


ORA-24306: bad buffer for piece

1 Answers  


ORA-40108: input data contains too few distinct target (string) values

1 Answers  


ORA-14459: missing GLOBAL keyword

2 Answers  


ORA-13292: incorrect ARC_TOLERANCE specification

1 Answers  


ORA-06260: NETNTT: cannot write to remote process

1 Answers  


ORA-25151: Rollback Segment cannot be created in this tablespace

1 Answers  


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

1 Answers  


ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY

1 Answers  


ORA-16067: activation identifier mismatch in archive log string

1 Answers  


PLS-00392: Type mismatch in arguments to BETWEEN

2 Answers  


Categories