DataType property mismatch error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
BillArr
Posts: 1
Joined: Fri 04 Nov 2011 10:57

DataType property mismatch error

Post by BillArr » Fri 04 Nov 2011 11:10

We have been seeing the error listed below for several months on various versions of Dot Connect for Oracle. Our current issue is an Oracle datatype of Number(1) being returned via ref cursor to a .Net (c#) dataset field with a datatype of Int32.

This combination works in hundreds of other fields in the same application, and the strange thing is we are not getting this error an another installation of the same application. All Oracle database versions are 11g R1 and R2.

We are currently running one release prior to the current. I have reviewed the release notes for the current release, and did not think that anything listed would address this issue.

Any help will be appreciated.

Type : System.Data.DataException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : .XXXXXXX and .XXXXXXX have conflicting properties: DataType property mismatch.
Source : System.Data

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 08 Nov 2011 15:11

This is a designed behaviour: Oracle Number(1) is mapped to .NET System.Int32 (for Entity Framework: Number(1) -> System.Boolean).

You can change the default mapping using the Number Mappings connection string parameter.

Post Reply