DataType property mismatch error

DataType property mismatch error

Postby 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
BillArr
 
Posts: 1
Joined: Fri 04 Nov 2011 10:57

Postby 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.
Shalex
Devart Team
 
Posts: 7703
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle