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
DataType property mismatch error
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.
You can change the default mapping using the Number Mappings connection string parameter.