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.O racleNumbe r to type System.IConvertible. Couldn't store <3975> in PERSON_ID column. Expected type is Decimal.
Please help! Any help is appreciated!
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.O
Please help! Any help is appreciated!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is it possibly a string with other characters around the numeric characters?
< and > for instance, or white space or quotes?