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-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrate

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL

1 Answers  


RMAN-06111: changed backup piece unavailable

1 Answers  


ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


ORA-16177: media recovery is not required

1 Answers  


ORA-31471: invalid OBJECT_ID value

1 Answers  


RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

1 Answers  


ORA-07681: sou2os: An error occurred while initializing Oracle

1 Answers  


ORA-09218: sfrfs: failed to refresh file size

1 Answers  


ORA-13480: the Source Type is not supported

1 Answers  


TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


Categories