Link to home
Start Free TrialLog in
Avatar of jwebster77
jwebster77

asked on

Unable to cast System.Data.OracleClient.OracleNumber

Hello all,

I have a OracleDataAdapter.  When I try to fill the dataadapter I am getting an error message that says:  Unable to cast object of type System.Data.OracleClient.OracleNumber to type System.IConvertible.  Couldn't store <3975> in PERSON_ID column.  Expected type is Decimal.

Please help!  Any help is appreciated!
Avatar of Sean Stuber
Sean Stuber

Are you sure your data input is an Oracle Number?

Is it possibly a string with other characters around the numeric characters?

< and >  for instance,  or white space or quotes?  
Avatar of jwebster77

ASKER

I have a oracledataadapter that is pulling data directly from the database.  I read somewhere that because it is a oracle number there are issues with converting it but i do not know how to fix it.
Can you post the code where you are reading and the table structure you are querying?
ASKER CERTIFIED SOLUTION
Avatar of sathyagiri
sathyagiri
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial