471,593 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,593 software developers and data experts.

Fill dataset is throwing out of the range of range exception.

Environment W2003K with Oracle 10 client connected to oracle using oracle odp provider.orcle is on solaries machine.

while filling the dataset .net is throughing the error "argument was out of the range of valid values".

we are getting error when trying to fill the dataset with more than 16 columns.

if any date column is avaible in retrivels then fill dataset method is throwing the bellow error.

Parameter name: Year, Month, and Day parameters describe an unrepresentable DateTime.

otherwise with out any date column then .net is throwing the bellow error.

arithmetic operation overflow

what could be the reason.when we conncted to oracle windows version it is working fine(if more then 16 columns also)

we are facing the problem becouse of oracle database on solaries or any other reason?

Any help or any document or any URLs regarding this issue will be appreciated.

Thanks in advance.
Jul 3 '06 #1
1 4076
Did anyone ever recieve an answer to this one? We are have the same exception on DataAdapter.Fill when loading a row from table in Oracle9i and 10g. We are using the System.Data.OracleClient adapter.

I am wondering if there is something odd in the database configuration that is not immediately evident by just doing a describe on the table. I say this because we have another table with a date column and we can fetch rows from that column without a problem. Also, we did not have this issue until we moved to a new database (and new dba).

So, it would seem something environmental with the host hardware or database configuration / table/column configuration is wrong or different.

Hope someone has some answers.

Thanks much, David
Sep 28 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by bardo | last post: by
2 posts views Thread by Dan | last post: by
3 posts views Thread by Pawel Blochowiak | last post: by
2 posts views Thread by Stanav | last post: by
2 posts views Thread by slinky | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.