Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

Last post 11-29-2007 3:31 AM by srmraja83. 2 replies.

Sort Posts:

  • Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

    06-23-2007, 12:17 AM
    • Member
      point Member
    • avais2006
    • Member since 06-18-2007, 5:54 AM
    • Posts 1

    i creat connection easlly and fatch data from oracle and delete also easlly uisng "SQLDataSource" for "GridView"  accessing Oracle Data Base but when i wish to do "UpDate" it give me the execption "System.Data.OracleClient.Oracle Exception:ORA-12704:Character Set MisMatch" and application crashed

    Please if any one know how to solve

  • Re: Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

    06-23-2007, 6:30 AM
    Answer
    • All-Star
      62,541 point All-Star
    • TATWORTH
    • Member since 02-04-2003, 8:34 AM
    • England
    • Posts 12,209
    • TrustedFriends-MVPs

     Have a look at

    • http://ora-12704.ora-code.com/
    • http://www.error-code.org.uk/view.asp?cl=ORACLE&p=ORA&ec=12704
    • http://www.issociate.de/board/post/167094/ORA-12704:_character_set_mismatch_problem_with_DBD::Oracle.html
    • http://forums.asp.net/p/938186/1182475.aspx
    • http://www.l4ndash.com/Log4NetMailArchive/tabid/70/forumid/1/postid/16484/view/topic/Default.aspx

    The following question arise:

    • Are you using ASP.NET 2.0 (GridView implies but it is always preferabel to explicitly state your environment)
    • Which version of Oracle are you working with?
    • What data is in the update? Is there anything unusual - e.g. numerics with leading zeros.
    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
  • Re: Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

    11-29-2007, 3:31 AM
    • Member
      2 point Member
    • srmraja83
    • Member since 09-08-2007, 9:07 AM
    • Posts 1

    Hi ,

      remove field type in update parameter and mention type="empty" for all fields.

Page 1 of 1 (3 items)