My Oracle Support Banner

Idbdataadapter.Fill Fails If Dataset Contains Nulls For Numeric Fields (Doc ID 268961.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Lite - Version 5.0.2.10.0 and later
z*OBSOLETE: Microsoft Windows 2000
Microsoft Windows CE

Symptoms

 The following error is occuring when trying to retrieve a number that contains a null in it. Using WinCe.Net in a C# application :

Throws error:
System exception
Value cannot be null Parameter name: String

To work around the error use the to_char(fieldname) function to convert the data. This only occurs on a number field. If the field is a varchar, the error does not occur.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.